Blog

Use the WideAwakeCoffee sheet. What is the covariance between Foot Traffic and Cups Sold? Please round your answer to two decimal places.

If the total sum of squares (SST) is 2,850.1 and the sum of squares due to error (SSE) is 600.2, what is the r-squared value? Please round your answer to four decimal places.

Use the ChainSupermarketsB dataset. This is the same data as the ChainSupermarketsA dataset, provided again on a separate sheet. Create a pivot table. Based on the pivot table, which city has the highest average revenue per store?

Use the ChainSupermarketsA dataset. Create a pivot table. Based on the pivot table, which city has the lowest total transactions?

If all forecast errors are positive, which of the following statements must be true?

Use the RestaurantTraffic Sheet. Use a multiple regression model to estimate daily visitors to a restaurant that is open Monday through Friday. You will need to account for: Day-of-week seasonal effect. Use Monday as your baseline. Time (a period variable, which increases by 1 each day) to capture the overall trend over time. What is the value of the coefficient on Thursday? One decimal place.

Use the InsurancePremium sheet. Develop a multiple linear regression model to predict the monthly car insurance premium based on the age of the driver and the type of car (sedan, SUV, or sports car). Use sedan as the baseline. What is the estimated monthly insurance premium for a 26-year-old driver with a sports car? Please round your answer to the nearest integer.

[Continued] Use the Enrollment sheet. Based on your regression model from the previous question, what is the predicted enrollment in Year 18? One decimal place.

[Continued] Use the Enrollment sheet. Based on your regression model from the previous question, what is the predicted enrollment in Year 18? One decimal place.

At the Nevermore Library, study sessions average 52 minutes with a standard deviation of 8 minutes. The session duration follows a normal distribution. Using the empirical rule, what percentage of sessions last between 36 minutes and 76 minutes? Please answer in one decimal place without the % mark.