Normal Distribution and Sales Essay

Submitted By Rome123
Words: 1998
Pages: 8
Open Document
MEMO
Lost Sales Analysis

Prepared by

Report Distributed October, 18 --

Prepared for
Low’s Depot, Home Improvement Center
TABLE OF CONTENTS 1. Introduction 3 2. Modeling Method 3 3. Results 4

1. Introduction
This memorandum will deal with questions submitted by Mr.. Low, CEO of Low's Depot, Oklahoma City, OK. Some background facts of the case; A storm occurred and caused major damage to the home improvement store. This in turn resulted to shut the store down for four months (September, October, November, and December).
Now the company wants to have enough evidence to convince the insurance company that the company really has made a great loss in these months, in order to obtain compensation, and there for there is two question that the company asked themself:
A: The amount of (regular) sales we would have received during the time we were closed.
B: The additional sales we would have received due to the extra business activity that we would have received because of the rebuilding activity that occurred after the storm.
Even thou over eight million dollars have flowed into the country, to build up the ruined provinces. The company did not have the right to take advantage of this, and now believes that they should receive compensation for the losses.
We have reviewed a table attached two data series, both tables provides with 48 months. The first table is the sales data from the store for the months immediately preceding the tornado, and the second one the sales for all home improvement stores and the total county-wide sales for the months that Lowe’s Depot were closed. 2. Modeling Method
In order to answer the questions that Lowe’s Depot been asking, I will perform a forecast based on the data series specified. The forecast will be based on seasonality with trend. With seasonality with trend meant a trend line in a year or less. The process measure interest in small time intervals, such as days, weeks, months or quarters. In our case, there will be monthly. This calculation is done to more easily figure out the numbers for next month. However, you should take into consideration that the numbers that are calculated is not precise. To be able to do such a calculation I will use a so called regression, which is a data analyze. A regression makes it possible to draw a strait line and shows the increase every month. Without any regression you only will get a lot of numbers without any sense. The regression is a branch of statistics, where the goal is to create a function that best fits the observed data.
The aim is basically to investigate the relationship between a dependent variable and one or more independent variables. This method also explores relations that can be described by straight lines or their generalization to numerous dimensions.
The method is used to more easily handle temporary increases or decreases in the company. These temporary increases or decreases may include for example a store. 3. Result A) Estimate the sales that would have occurred at the store if there had been NO tornado.
Below you will see a table with all your sales. I will calculate the regression from the data with help from the trends and all the Dummys.

SUMMARY OUTPUT | | | | | | | | | | | | | | | | | | Regression Statistics | | | | | | | | Multiple R | 0.945755452 | | | | | | | | R Square | 0.894453374 | | | | | | | | Adjusted R Square | 0.829694531 | | | | | | | | Standard Error | 0.325656444 | | | | | | | | Observations | 48 | | | | | | | | | | | | | | | | | ANOVA | | | | | | | | | | df | SS | MS | F | Significance F | | | | Regression | 13 | 31.45580107 | 2.419677005 | 24.71725004 | 1.47035E-13 | | | | Residual | 35 | 3.711824183 | 0.10605212 | | | | | | Total | 48 | 35.16762525 | | | | | | | | | | | | | | | | | Coefficients | Standard Error | t
Show More

Related Documents: Normal Distribution and Sales Essay

Regression Analysis and Significance Essay example

the dependent variable is sale price of the house. There are nine dependent variables which are SQFT, BEDROOMS, BATHS, AGE, OWNER, POOL, TRADITIONAL, FIREPLACE and WATERFRONT. Meanwhile, OWNER, POOL, TRADITIONAL and FIREPLACE are dummy variables. This data set collected 864 houses sold over last year. The sample mean of the price is $155792.2 and median is $130000. The maximum is $1580000 and the minimum is $22000.the standard deviation is $130250. 2. The normal distribution is important because of…

Words 2289 - Pages 10

Continuous Probability Notes Essay

Chapter 6: Continuous Probability Distributions Study Modules (PPT presentations): Introduction to Continuous Probability Distributions Normal Probability Distribution Discrete Distributions Excel Tutorial: Computing Normal Probabilities Java Applet: Normal Distribution Areas Normal Approximation to Binomial Probabilities Continuous Random Variables: A continuous random variable can assume ____any value_______________ in an interval on the real line or in a collection of intervals…

Words 778 - Pages 4

Assignment 2 Essay examples

If the gasket production machine is working properly, the population of gasket OD measures can be reasonably modeled by a Normal distribution with mean OD = 400 mm and standard deviation OD = 2 mm. Use the spreadsheet named Asterex. a. 5 points: Find the values for the sample statistics indicated in column D. Use a built-in Excel function or formula when appropriate. Place the appropriate…

Words 1866 - Pages 8

Wal-mart Essay

2003 Walmart became the world’s largest retailer and posted sales of $245 billion with net income of $8 billion. This amazing accomplishment came hard fought and was driven by the founder, Sam Walton. His relentless passion for storewide efficiency is legendary and his innovations throughout the supply chain were groundbreaking for the industry. Along with reducing costs over the entire business enterprise, Sam Walton pioneered new distribution and inventory systems. He then leveraged the inventory data…

Words 785 - Pages 4

Research Method Assignment Essay

5 2.1 Basic statistic information about USASuperCars 5 2.1.1 Distribution, mean and standard deviation of certain renvenue 5 2.1.2 Probability of the revenue level 6 2.2 HSBC offers…

Words 3077 - Pages 13

Essay on Normal Distribution and Example

Chapter 7: Inference for Distributions A visual comparison of normal and paranormal distribution Lower caption says 'Paranormal Distribution' - no idea why the graphical artifact is occurring. http://stats.stackexchange.com/questions/423/what-is-your-favorite-data-analysis-cartoon 2 7.1: Inference for the Mean of a Population - Goals • Be able to distinguish the standard deviation from the standard error of the sample mean. • Be able to construct a level C confidence interval (without knowing )…

Words 2224 - Pages 9

lexture notes Essay

we began our study of statistical inference by describing how we could select a random sample and then use the sample values to estimate the value of a population parameter. Recall that a sample is a part or subset of the population, while a parameter is a value calculated from the entire population. In Chapter 9 we estimated a population parameter from a sample statistic. In addition, we developed a range of values, called a confidence interval, within which we expected the population value to be…

Words 3186 - Pages 13

Sst4e Tif 07 Essay

Ch. 7 The Normal Probability Distribution 7.1 Properties of the Normal Distribution 1 Use the uniform probability distribution. MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question. Provide an appropriate response. 1) High temperatures in a certain city for the month of August follow a uniform distribution over the interval 64°F to 92°F. What is the probability that a randomly selected August day has a high temperature that exceeded 69°F? A) 0.8214…

Words 7347 - Pages 30

Essay on Normal Distribution and Fo  Fe

hypothesis comparing an observed set of frequencies to an expected distribution. LO2 List and explain the characteristics of the chi-square distribution. LO3 Conduct a goodness-of-fit test for unequal expected frequencies. LO4 Conduct a test of hypothesis to verify that data grouped into a frequency distribution is a sample from a normal distribution. LO5 Use graphical methods to determine if a set of sample data is from a normal distribution. LO6 Conduct a test of hypothesis to determine whether two 17-2…

Words 2078 - Pages 9

Essay about Stats Final guide

(1) A study of the number of cars sold looked at the number of cars sold at 500 Dealers The smallest dealer had 11 cars sold and the largest had 154 cars sold. If you were going to create a frequency distribution of the number of cars sold using six classes in your frequency distribution, which of the following might be a reasonable first class? (a) 0 to 25 _ (2) Give that a sample of 25 had x =…

Words 2989 - Pages 12