Perform descriptive analytics on the data (e.g., calculate the average sales, average family income, etc.) What insights can you draw from this analysis?

INSTRUCTIONS TO CANDIDATES

ANSWER ALL QUESTIONS

Individual Analytics Assignment – 15%

Sarah owns a specialty food store in your neighbourhood.  She heard that you are taking an analytics course and has come to you for help.  To assist with this, Sarah has provided you with a sample of 200 randomly selected sales transactions which took place over a 30-day period.

 

Question 1 – 10 marks

a) Perform descriptive analytics on the data (e.g., calculate the average sales, average family income, etc.) What insights can you draw from this analysis? /4

b) What charts can you create that can help draw more insights / knowledge?  /3

c) Were there any issues or outliers with the data?  If yes, what actions did you take and why? /3

 

Provide a write-up of your findings and the work you performed.

 

Question 2 – 15 marks

Build a regression model that will help predict sales.  

a) Develop scatter charts.  What does the scatter chart indicate about the relationship between sales and the independent variables?  /4

b) Perform regression model analysis and recommend a final model.  Explain how you came up with your recommended model and show your work.  /5

c) Are there variables that are not that predictive that could be eliminated? What are they and how did you determine this? /3

d) What changes and/or suggestions would you make (e.g., changes in the data collection process) that could help improve the model?  /3

 

Question 3 – 5 marks

a) How would you explain the results of this model (e.g., how could Fatima implement or use the model) to Fatima who has no background in analytics? /5

 

Attachments:

Expert's Answer

360 Times Downloaded

Related Questions

. The fundamental operations of create, read, update, and delete (CRUD) in either Python or Java

CS 340 Milestone One Guidelines and Rubric  Overview: For this assignment, you will implement the fundamental operations of create, read, update,

. Develop a program to emulate a purchase transaction at a retail store. This  program will have two classes, a LineItem class and a Transaction class

Retail Transaction Programming Project  Project Requirements:  Develop a program to emulate a purchase transaction at a retail store. This

. The following program contains five errors. Identify the errors and fix them

7COM1028   Secure Systems Programming   Referral Coursework: Secure

. Accepts the following from a user: Item Name Item Quantity Item Price Allows the user to create a file to store the sales receipt contents

Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip

. The final project will encompass developing a web service using a software stack and implementing an industry-standard interface. Regardless of whether you choose to pursue application development goals as a pure developer or as a software engineer

CS 340 Final Project Guidelines and Rubric  Overview The final project will encompass developing a web service using a software stack and impleme