Data analysis

Complete the following tasks submitting a power point along with the Excel file with your computations. Use the power point template provided.
Complete a full data analysis exercise including:
• Summary/descriptive statistics (use the pivot table to provide information on the counts/percentages, with one variable at a time, and with two variables at a time);
• Linear regression (ensure to enable the analysis toolkit function in Excel, and select the appropriate dependent variable and explanatory variable, as seen in class. You
can have more than one linear regression, each time with a different explanatory variable);
• Recommendations based on the results you produce (provide a short summary of your findings and any key take away).

Sample Solution