Download the data file BigMartSales.xlsx. This file contains sales data on different items at multiple outlets of a major retailer. Note that the data is at three levels: item-level, store-level, and city level. Data definitions are provided on "Data Definition" of the Excel spreadsheet.
1. We want to analyze how sales vary by outlet type: Grocery store versus Supermarket Type 1, 2, or 3. Ignore city information for this analysis. Conduct the necessary analysis and present the output in a nice, concise manner. Interpret the findings of this analysis, i.e., which type of store has the highest sales, by what amount, etc.
2. We also want to analyze if sales vary by city type: Tier 1, 2 and 3. For this analysis, you have to account for both city and outlet. Again, conduct the necessary analysis in a succinct way and present the results and interpretation of your analysis.
For each analysis, you must first choose the predictors of interest and your three best models for comparison. You can assume linear relationships. If you have to make any additional assumptions, clearly list the assumptions that you made. Submit the models that you ran, the output, and interpretation in one single, properly formatted Word document, appended with your entire R code. Explain clearly any choices that you make, such as choice of predictors, models, and/or assumptions.
NOTE: Unnecessary or cluttery code, lack of comment statements, and a dump of copied-and-pasted R output will lose 20% of the grade right off the top. Please also note that this is a more difficult assignment than any prior assignment and is worth 10 points. Points will be assigned as follows:
1. Choice of predictors (sufficiently explained) for each model: 1+1 points
2. Appropriate models (with explanation and summarized output): 4 points
3. Interpretation: 2 points
4. Cleanliness of code and output: 2 points
Just FYI: i am attaching a sample solution. I need Multiple models and I think Professor wants to use Multi-level, Mixed-Level & Panel Models to be created and explained in detail. Please see sample_solution file.
Need R-code file with good commenting as well.