When the data are large and when it is difficult to analyze all ...

[craiczarry]

When the data are large and when it is difficult to analyze all at once, which of the following feature in Excel is used to make the data more manageable and to develop insights?
 a. Frequency table
  b. Sorting and filtering
  c. Fill color
  d. Charts

Question 2

A multiple regression equation has been developed for y = daily attendance at a community swimming pool, x1 = temperature (degrees Fahrenheit), and x2 = weekend versus weekday, (x2 = 1 for Saturday and Sunday, and 0 for other days of the week.) For the regression equation shown below, interpret each partial regression coefficient: y = 100 + 10x1 + 175x2.

[Sweetkitty24130]

Answer to Question 1

B

Answer to Question 2

The partial regression coefficient for x1 implies that, holding the day of the week constant, a one degree Fahrenheit increase in the temperature will result in an increase of 10 in attendance. The partial regression coefficient for x2 implies that the attendance increases by 175 people on Saturdays and Sundays (assuming a constant temperature).