Least squares regression to predict amount spend

Assignment Help Basic Statistics
Reference no: EM1396981

Super Markets, Inc. is considering expanding into the Scottsdale, Arizona, area. Ms. Luann Miller, Director of Planning, must present an analysis of the proposed expansion to the operating committee of the board of directors. As a part of her proposal, she needs to include information on the amount people in the region spend per month for grocery items. She would also like to include information on the relationship between the amount spent for grocery items and income. She gathered the following sample information.

Monthly Monthly Monthly Monthly
Household Amount Income Household Amount Income

1 $555 $4,388 21 $ 913 $6,688
2 489 4,558 22 918 6,752
3 458 4,793 23 710 6,837
4 613 4,856 24 1,083 7,242
5 647 4,856 25 937 7,263
6 661 4,899 26 839 7,540
7 662 4,899 27 1,030 8,009
8 675 5,091 28 1,065 8,094
9 549 5,133 29 1,069 8,264
10 606 5,304 30 1,064 8,392
11 668 5,304 31 1,015 8,414
12 740 5,304 32 1,148 8,882
13 592 5,346 33 1,125 8,925
14 720 5,495 34 1,090 8,989
15 680 5,581 35 1,208 9,053
16 540 5,730 36 1,217 9,138
17 693 5,943 37 1,140 9,329
18 541 5,943 38 1,265 9,649
19 673 6,156 39 1,206 9,862
20 676 6,603 40 1,145 9,883

a. Let the amount spent be the dependent variable and monthly income the independent variable. Create a scatter diagram, using a software package.

b. Determine the regression equation. Interpret the slope value.

c. Determine the coefficient of correlation. Can you conclude that it is greater than 0?

Reference no: EM1396981

Questions Cloud

List and explain description for europe-s population trends : List and explain three description for Europe's population trends since 1950. For instance, in United States, there was large population increase beginning in 1950s
Difference between identity and conservation of amino acids : What is the difference between conservation of amino acids vs. the identity of amino acids residues in a multiple sequence alignment?
Predict yearly sales for home depot : Determine the least squares equation. On the basis of this information, what are the estimated sales for 2005?
How glycolysis becomes critical to cellular atp production : Explain how glycolysis becomes critical to cellular ATP production during severe hypoxia. Your answer should mention the allosteric regulators that accelerate glycolysis.
Least squares regression to predict amount spend : Super Markets, Inc. is considering expanding into the Scottsdale, Arizona, area. Ms. Luann Miller, Director of Planning, must present an analysis of the proposed expansion to the operating committee of the board of directors.
Distribution of the breaking strength : A beverage company is trying to ?nd out the distribution of the breaking strength of their glass bottles. Fifty bottles are selected at random and tested for breaking strength, with the following results (in pounds per square inch):
Write report to explain history and symptoms of bell-s palsy : Write down medical report explaining the history, symptoms, and physical examination results of the patient with Bell's Palsy.
Use of statistical tools and surveys in business : Describe ways in which the use of MS Excel as a tool for interpreting data can be used by a manager of an organization.
Mean score on a standardized test : A mean score on a standardized test is 50 with a standard deviation of 10. Answer the following

Reviews

Write a Review

Basic Statistics Questions & Answers

  Hypothesis test for difference between population proportion

Using alpha = 0.05 and a computed value of +4.49, can we conclude that the percentage of claims for married policyholders is less then for single policyholders?

  Proportion of sps professors

Suppose sps professors have an average life normally distributed of 82 years, with a population standard deviation of 5 years.

  Mean number with standard deviation

The mean number of passengers per flight is 160 with a standard deviation of 20. The aircraft used for the route has 200 seats.

  Concept of dependent and independent variables

In business, investors are always interested in the tradeoff between returns and risk. Regression analysis is a statistical technique that can be used to quantify this risk.

  What are the upper and lower control limits

When using past data, I have found that the proportion of items rejected by quality control personnel is about 3%. We normally make 5000 items per day. For a p chart, what are the upper and lower control limits?

  Capability of a process refers to

A company makes camshafts. The camshaft lengths need to be within a certain tolerance or they will not fit. They have produced x bar and s charts

  Distribution of normal probability

Micron Electronics makes both desktop and laptop personal computers that they sell directly to customers by phone or over the Internet.

  Simple linear regression model using excel

Make a forecast for 2004, using either the fitted trend model or a judgment forecast. Why is it best to ignore earlier years in this data set?

  Mean absolute deviation using moving average

Calculate the mean absolute deviation based on the 2-day moving average. You can have a forecast and an actual temperature.

  Determining z values

Find out z values for 29 and 34 hours. What percent of garages take between 32 hours and 34 hours to erect?

  Evidence of the mean dimension

The dimension is supposed to be 224 mm and the variability of the manufacturing process is unknown. Is there evidence that the mean dimension is not 224 mm?

  Information about descriptive statistics and probability

What is the relationship between descriptive statistics and Affirmative Action ? Can using probability in market trending decisions lead to a bad decision? Explain?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd