Build business case explain how predict walmart store sales

Assignment Help Applied Statistics

Reference no: EM132360251

Assignment -

Use the data build a business case explaining how we can predict Walmart store Sales.

"You are provided with historical sales data for 45 Walmart stores located in different regions. Each store contains a number of departments, and you are tasked with predicting the department-wide sales for each store.

In addition, Walmart runs several promotional markdown events throughout the year. These markdowns precede prominent holidays, the four largest of which are the Super Bowl, Labor Day, Thanksgiving, and Christmas. The weeks including these holidays are weighted five times higher in the evaluation than non-holiday weeks. Part of the challenge presented by this competition is modeling the effects of markdowns on these holiday weeks in the absence of complete/ideal historical data.

stores.csv - This file contains anonymized information about the 45 stores, indicating the type and size of store.

train.csv - This is the historical training data, which covers to 2010-02-05 to 2012-11-01. Within this file you will find the following fields:

Store - the store number
Dept - the department number
Date - the week
Weekly_Sales - sales for the given department in the given store
IsHoliday - whether the week is a special holiday week

test.csv - This file is identical to train.csv, except we have withheld the weekly sales. You must predict the sales for each triplet of store, department, and date in this file.

features.csv - This file contains additional data related to the store, department, and regional activity for the given dates. It contains the following fields:

Store - the store number
Date - the week
Temperature - average temperature in the region
Fuel_Price - cost of fuel in the region
MarkDown1-5 - anonymized data related to promotional markdowns that Walmart is running. MarkDown data is only available after Nov 2011, and is not available for all stores all the time. Any missing value is marked with an NA.
CPI - the consumer price index
Unemployment - the unemployment rate
IsHoliday - whether the week is a special holiday week

For convenience, the four holidays fall within the following weeks in the dataset (not all holidays are in the data):

Super Bowl: 12-Feb-10, 11-Feb-11, 10-Feb-12, 8-Feb-13

Labor Day: 10-Sep-10, 9-Sep-11, 7-Sep-12, 6-Sep-13

Thanksgiving: 26-Nov-10, 25-Nov-11, 23-Nov-12, 29-Nov-13

Christmas: 31-Dec-10, 30-Dec-11, 28-Dec-12, 27-Dec-13"

Note - Need SPSS analysis + 5 pages report? Don't need a huge report just enough data charts etc and explanations on how those findings are relevant. And write the report based on the analysis. Just need to understand what they mean.

Attachment:- SPSS Analysis Assignment File.rar

Reference no: EM132360251

Questions Cloud

Flexibility in the labour market in developed nations : Globalization engenders positive benefits via enhancing flexibility in the labour market in developed nations.

Conclusion concerning the null hypothesis : In a survey of 120 publicly-traded companies, the average price-earnings ratio was 18.5 with a standard deviation of 8.2.

Average cholesterol level of people : In a sample of 85 people who have had strokes, the average cholesterol level was 255 with a standard deviation of 43. In order to test the hypothesis

What is the average bill for these members : Suppose the country club bills based on a sample of 4 members are: 396, 1,070, 708, 663. What is the average bill for these members?

Build business case explain how predict walmart store sales : Assignment - Use the data build a business case explaining how we can predict Walmart store Sales. Need SPSS analysis + 5 pages report

What is your average in the class so far : What is your average in the class so far? (please round your answer to 1 decimal place)

What is the probability that the dvd player : What is the probability that the DVD player that you just bought will last longer than 12 years (144 months) (please round your answer to 4 decimal places)

Converge in the solow model : They will never converge according to the endogenous model but they would converge in the Solow model.

Explain what emission standards are and use a graph : Explain what emission standards are and use a graph to illustrate. a. Do victims have incentive to report lower or higher marginal damages?

User Account

All Pages