Create a pivot table expressing the total sales per store

Assignment Help Database Management System

Reference no: EM133393479

Question: Using this data set:HW4_Data.xlsx Download HW4_Data.xlsx perform the following analyses:

- Create a pivot table expressing the total sales per store per year

- Take the weekly data from the top selling store and perform the following:
o Plot the data, provide the plot, and comment on what you observe
o Create a forecast with the following methodologies (optimize the alpha/beta/gamma based on the MAD):
• Exponential smoothing
• Holt Method
• Winter Method
• Holt-Winter Method
o Which forecast is best and why?

Attachment:- Pivot table.rar

Reference no: EM133393479

Questions Cloud

Write the equation for the world population : Write the equation for the world population, P, as a function of the years since 1800. (keep four decimal places): Identify the slope of the linear model

Perform separate abc analysis for the largest spend customer : Perform an ABC analysis on all SKUs and report the percentage breakdown of A/B/C items and Perform a separate ABC analysis for the largest spend customer

What does a type toke ratio measure : List 3 activites you could use when obtaining a language sample What does a Type Toke Ratio measure? What is a good number of utterances to obtain from

Compare and contrast the procaryotic replication fork : Compare and contrast the procaryotic replication fork with the eucaryotic replication fork. What are the similarities and differences between the two?

Create a pivot table expressing the total sales per store : Create a pivot table expressing the total sales per store per year and Plot the data, provide the plot, and comment on what you

Are you using graphics that are pertinent to the information : Are you using graphics that are pertinent to the information you are presenting? Are those graphics enhancing the readability and useability of the poster

Describe a key concept from the videos below and pose : Describe a key concept from the videos below and pose a question for each on something that maybe was difficult or note understood about the content.

How can we regulate the hbp issues : how can we avoid it, how can we regulate the HBP issues, and what are the sequels for people who suffered a stroke?

How body size affects the metabolic rate of an animal : Which animal, mouse or elephant, has more energy requirements high per unit mass? Explain How body size affects the metabolic rate of an animal?

User Account

All Pages