Overview
Module 6, Assignment 1: Analyzing Data to Craft Strategy
For this assignment, please follow the instructions below.
- Take a quick glance at the ‘Assignment 1 Spreadsheet Download Assignment 1 Spreadsheetto get yourself familiarized with the nature of the dataset. This is a dataset of the customers and social media activity of a restaurant/bar.
- So far in this semester, you have performed analyses on various datasets. You are already familiar with the statistical concept of ‘correlation.’
- Before you continue, there are few additional tools to learn; i.e., descriptive statistics, graphs, and forecasting.
- For descriptive statistics in Windows Excel, watch, https://www.youtube.com/watch?v=4_9vGqQaCFkLinks to an external site.. For Mac, watch, https://www.youtube.com/watch?v=25Lb8TA_QtsLinks to an external site..
- Report the following and explain what they mean. Mean, standard error, min, max, and range.
- Visualizing data always helps with understanding what is going on over time. To refresh your memory on graphs in Excel in Windows, you can watch https://www.youtube.com/watch?v=3PwVWX28dEELinks to an external site.. Mac users can watch https://www.youtube.com/watch?v=gErjs_HrkvALinks to an external site..
- Over the period of 10 days, draw one graph of followers over the 10-day period and one graph of likes over the 10-day period. Are the graphs similar in nature (i.e., both increasing or decreasing)?
- Next, given that ‘the number of customers’ is probably the most important part of our dataset, we are interested in forecasting the number of customers in ‘Day 11’.
- For a refresher on forecasting in Excel, please see https://www.youtube.com/watch?v=g6KCZOfBONULinks to an external site..
- Now, you can forecast the number of customers for Day 11.
- Please bear in mind that your report should inculde details of all of the steps described above.
View Rubric
| Module 6: Analyzing Data to Craft Strategy Rubric | ||
|---|---|---|
| Criteria | Ratings | Pts |
| Descriptive Statistics | 45 pts Excellent All descriptive statistics are correct11.25 pts Needs Improvement One or two descriptive statistics are correct0 pts Not Evident No Information | / 45 pts |
Visualization | 45 pts Excellent All graphs are correct22.5 pts Needs Improvement One graph is correct0 pts Not Evident No Information | / 45 pts |
Forecasting | 60 pts Excellent Forecast for Day 11 is correct0 pts Needs Improvement No Information0 pts Not Evident Forecast for Day 11 is incorrect | / 60 pts |
| Total Points: 0 |