Forecasting and Business Analysis

Assignment Extract

Background The data contained in the spreadsheet “Corner Store.xls” (located in the same folder as this document) provide information relating to the gross monthly sales of a hypothetical corner store chain. Each observation in the data represents a corner store at a different location. The data incorporate observations from different cities and states (but all in Australia). For each corner store, (i=1,2,….,50) , the variables you have been given are: 1. Gross monthly sales ($) 2. The number of competitors within 10km 3. The population (in 1000’s) within 10km 4. The average income of the population within 10km ($) 5. The average number of cars owned by households within 10km 6. The median age of dwellings within 10km You have been approached by the owners of this corner store chain to conduct a statistical analysis. They are looking to open new corner stores in several areas where they are currently not operating. Hence, they are interested in the determinants of gross sales, and in predicting the characteristics of the areas they should be considering for the establishment of new corner stores. Task Write a report for the corner store chain owners. The report should provide a brief summary of the data, justification of the variable(s) that you consider to be relevant, and analysis of your results (including your interpretation of the results and any diagnostic tests you have conducted). You should also highlight any limitations in your analysis and suggestions for improving this research that you feel to be appropriate. You need to do some excel. If u need some help u can look my school web for this course http://learn.unisa.edu.au/course/view.php?id=130685 Name: shiwy015 Password:11Calvin18