Unfortunately, your specific data request has been rejected by the franchise owners. However, they have provided a data set that includes a number of useful variables for the past 52 weeks. The data is in the Excel file and descriptions of the variables are available in your team OneNote as well as below.

Use this data, as best you can, to forecast the demand for economy cars in the next four weeks. It would be even better if you could suggest a specific rate that we should charge for the economy category to maximize revenue. How many vehicles do you expect to be rented at the rate you are suggesting? Do we need to worry about increasing our fleet if we follow your demand forecast?

In your response, include not only your forecast and response to the questions, but also explain why you have chosen the specific independent variables you have used in your regression model and their expected signs. Be sure to discuss the goodness of fit of your model, and the statistical significance of the regression coefficients.

How many vehicles do you expect to be rented at the rate you are suggesting? Do we need to worry about increasing our fleet if we follow your demand forecast? How much should you charge for the economy cars to maximize revenue?

week	PownE	PownL	Pcomp	session	weather	unempl	flightswk	cancwk	holiday	wrecks	Discount	Upgrade	TotlAd	AdBlbd	AdPaper	AdTV	QE	Q_length	Age<25	Age25_50	Age51+	Q_length	E_days	FleetAge	BedTax
1	29.99	37.99	37.75	0	4	701	41	9	0	22	8	2	430	430		0	87	334	9	64	14	334	3.839	50.3	$104,025.67
2	29.99	41.99	41.5	0	1	739	41	2	0	16	7	1	430	430		0	76	327	13	46	17	327	4.303	51.3
3	24.99	26.99	35.25	0	2	814	41	3	0	12	8	1	430	430		0	82	315	20	51	11	315	3.841	52.3
4	28.99	37.99	35.5	1	1	880	47	0	1	6	7	1	430	430		0	77	275	24	42	11	275	3.571	53.3
5	24.99	36.99	24.5	1	0	881	47	0	0	10	7	1	430	430		0	76	316	20	51	5	316	4.158	54.3