Module 6, Assignment 1: Analyzing Data to Craft Strategy For this assignment, please follow the ins ...

---

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 Module 6: Analyzing Data to Craft Strategy Rubric Criteria Ratings Pts Descriptive Statistics 45 pts Excellent All descriptive statistics are correct 11.25 pts Needs Improvement One or two descriptive statistics are correct 0 pts Not Evident No Information / 45 pts Visualization 45 pts Excellent All graphs are correct 22.5 pts Needs Improvement One graph is correct 0 pts Not Evident No Information / 45 pts Forecasting 60 pts Excellent Forecast for Day 11 is correct 0 pts Needs Improvement No Information 0 pts Not Evident Forecast for Day 11 is incorrect / 60 pts Total Points: 0