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

  Finding width of confidence interval around population mean

For this same sample of n = 45, find out the width of confidence interval around population mean?  Illustrate all work.

  Examples of measures of central tendency-variation

Critically discuss how someone may use measures of central tendency, variation, or position in their home, school, or workplace.

  Difference in voting patterns

Can we conclude a difference in voting patterns for men vs. women? YES or NO (circle one)

  Finding critical z value

Find the critical value z that corresponds to the given confidence level of 90%.

  Construct interval estimates for the population

Construct the 90% and 95% interval estimates for the population mean weekly sales.

  Chance of detecting a significant difference

How many participants need to be enrolled in each group to have 90% chance of detecting a significant difference using a two-sided test with a a= .05 if compliance is perfect?

  Determining the probability and variance

Find out the variance for percentage of tickets? Determine the probability that your sample will have the average between 70 and 75?

  Slope in the linear regression model

In fitting the simple linear regression model Yi ~ N (α + β xi, σ 2 ) to the following data:

  Find the explanatory variables in this study

The height and diameter of 31 trees of a certain species were measured, the trees were cut down, and the volume of usable lumber was determined. Find the explanatory variable(s) in this study are

  Explaining sample space

If these answers were combined into single statistic, how could we explain sample space? Mention how many elements are in sample space?

  Symmetrical-limits of population percentage

The probability is 90% that the sample percentage will be contained within what symmetrical limits of the population percentage?

  Compute the correlation among the variables

Compute the correlation among the variables. Describe perfect correlation also negative correlation. Utilize the following data to answer questions related.

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