The ski season started in Mount Sunapee! The ski and snowboard rental shop is located in the ski lodge area and offers a large selection of current snowboards, shaped skis, and helmets for children, women, and men. The winter rental shop is open every day that Mount Sunapee is open for skiing. The rental store maintains a current inventory of quality rental equipment with all rental equipment inventory replaced on a normal rotation basis every three to four years.

The owner of the store wants to understand better the factors that affect the demand for his ski and snowboard rental shop, so he can plan his capacity better. In particular, he wants to know how different factors, as the day of month, weekends, weather or school breaks affect their demand.

You will find data on number of rentals per day for December 2015 in this spreadsheet:

Date	Day	Weekend	Weather (good snow)	School Break	Shaped Ski Rentals	Snowboard Rentals	Helmet Rentals
12/1/2015	1	0	0	0	25	8	15
12/2/2015	2	0	0	0	22	5	10
12/3/2015	3	0	0	0	26	7	15
12/4/2015	4	0	0	0	35	10	20
12/5/2015	5	1	0	0	90	25	65
12/6/2015	6	1	0	0	85	20	62
12/7/2015	7	0	0	0	28	6	15
12/8/2015	8	0	0	0	22	5	12
12/9/2015	9	0	0	0	25	5	15
12/10/2015	10	0	0	0	28	7	17
12/11/2015	11	0	0	0	35	8	20
12/12/2015	12	1	1	0	120	35	85
12/13/2015	13	1	1	0	105	28	95
12/14/2015	14	0	1	0	48	15	32
12/15/2015	15	0	0	0	25	5	15
12/16/2015	16	0	0	0	35	8	21
12/17/2015	17	0	1	0	45	12	28
12/18/2015	18	0	1	0	60	15	37
12/19/2015	19	1	1	0	130	42	90
12/20/2015	20	1	1	0	110	32	80
12/21/2015	21	0	1	0	70	15	39
12/22/2015	22	0	1	0	53	7	30
12/23/2015	23	0	1	1	85	18	49
12/24/2015	24	0	1	1	90	22	55
12/25/2015	25	0	1	1	110	35	70
12/26/2015	26	1	1	1	170	45	105
12/27/2015	27	1	1	1	190	50	120
12/28/2015	28	0	1	1	110	42	75
12/29/2015	29	0	1	1	90	35	65
12/30/2015	30	0	1	1	75	28	50

Q1. The owner of the winter rental shop wants you to analyze how weekends affect his daily demand for shaped ski rentals, since he has noticed that more people rent shaped skis on weekend days (e.g. Saturday and Sunday) than on weekdays (e.g. Monday through Friday). Create a regression model of shaped skis daily rentals as a function of weekends. Use as only independent variable a dummy variable with a value of 1 for weekend days and 0 for the weekdays. What is theR2value for this model? Enter your answer in decimal form using three decimal places.

Q2. Create now a multivariate regression model using three independent variables: weekend, school break, and weather as predictors of the shaped ski rentals. For weather use a dummy variable with a value of 1 for those days that the quality of snow were good. What is the adjustedR2value for this model? Enter your answer in decimal form using three decimal places.

Q3. According to the previous (Part 4) multivariate regression model that you have created using three independent variables: weekend, school break, and weather as predictors of the shaped ski rentals, which is the value of the intercept? Enter your answer rounded to four decimal places.

Q4. Based on your previous experience working on another ski rental shop located in Vermont (US), you believe that school breaks affect the daily rental demand for shaped skis. You also think that a better model could be obtained by using a multiple regression approach. Your proposal is to analyze three different models to predict shaped ski rentals using two independent variables in each model: (A) one model using the day of month and weekend as the independent variables, (B) another using the day of month and school break as independent variables, and (C) a last one using weekend and school break as independent variables. Which of these models is the best considering predictive power and statistical significance of coefficients?

Select the best answer

A.The model using the day of month and weekend is the best

B.The model using the day of month and school break is the best

C.The model using weekend and school break is the best

D.The model using only weekend (from Part 2) is better than any of these