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 attached to the right.

$$

Your team should 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?

$$

While you should work on the data analysis$/$regression$/$forecast as a team, each member of your team must write their own memo$/$mini report for this assignment. In your response, include not only your forecast and response to the questions above, 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. You should also submit an Excel file $($or output from whatever regression software used$)$ showing full results from any analyses. These documents should be submitted through the Assignments$/$Dropbox$.$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 attached to the right.

$$

Your team should 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?

$$

While you should work on the data analysis$/$regression$/$forecast as a team, each member of your team must write their own memo$/$mini report for this assignment. In your response, include not only your forecast and response to the questions above, 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. You should also submit an Excel file $($or output from whatever regression software used$)$ showing full results from any analyses. These documents should be submitted through the Assignments$/$Dropbox$.$