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 in the Word file attached below.
Use this data, as best you can, to forecast the demand for “economy” cars in the next four weeks. You are not limited to five variables, use as many or few as you see fit. 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.
You should also submit an Excel file (or output from whatever regression software used) showing full results from any analyses.