Perform descriptive analytics on the data set

Reference no: EM133182347

Analytics Assignment

Leylah owns a specialty food store in your neighbourhood. She heard that youare taking ananalytics course and has come to you for help. To assist with this,Leylah has provided you witha sample of 150 randomly selected salestransactions which took place over a 30-day period.

Question 1 -
a) Perform descriptive analytics on the data set (e.g., calculate the mean,median, etc.) What insights can you draw from this analysis?
b) What charts can you create that can help draw more insights / knowledge?
c) Are there any issues or outliers with the data? If yes, what actions did youtake and why?
Provide a write-up of your findings and the work you performed.

Question 2 -
Build a regression model that will help predict sales.
a) Develop scatter charts. What does the scatter chart indicate about the relationship between the dependent and the independent variables?
b) Perform regression analysis and recommend a final model. Explain how youcame up withyour recommended model and show your work.
c) Are there variables that are not that predictive that could be eliminated? Whatare they and how did you determine this?
d) What changes and/or suggestions would you make (e.g., changes in whatdata was collected, etc.) that could help improve the model?

Question 3 -
a) How would you explain the results of your recommended model (e.g., howcould Leylah implement or use the model) to Leylah who has no backgroundin analytics?

Reference no: EM133182347

Questions Cloud

Find service delivery models : What are two typical self-service platforms that Human Resource departments can use as the basis for service delivery models that enable data to be accessed and

Implementation of an occupational health and safety program : Identify some of the main barriers to the implementation of an occupational health and safety program in most organizations, as well as strategies to break thro

Develop a decision tree that can be used to solve problem : Develop a decision tree that can be used to solve Chang's problem. You can assume in this part of the problem that she is using EMV (of her net profit)

What is transfer of training : Paraphrase and use your own words in the answer - DO NOT COPY FROM WEBSITES the course is Human Resources information system

Perform descriptive analytics on the data set : Perform descriptive analytics on the data set (e.g., calculate the mean,median, etc.) Whatinsights can you draw from this analysis

How many pounds of pepperoni would you order : An American distributor stops by every six weeks to take orders. How many pounds of pepperoni would you order

What is academic plan at kean : What is your academic plan at Kean? What are your goals for your current and future classes? How do these goals align with your long-term plan you set up in the

Lewin three-step process for change : Consider in detail Lewin's three-step process for change. Which of the three steps do you think would be hardest? How could you develop your ability to apply th

Discuss the role of human resource officer as a counsellor : Discuss the role of Human Resource Officer as a counsellor. Please support your response with citations from two main theorists.

User Account

All Pages