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

  Statistics-probability assignment

MATH1550H: Assignment:  Question:  A word is selected at random from the following poem of Persian poet and mathematician Omar Khayyam (1048-1131), translated by English poet Edward Fitzgerald (1808-1883). Find the expected value of the length of th..

  What is the least number

MATH1550H: Assignment:  Question:     what is the least number of applicants that should be interviewed so as to have at least 50% chance of finding one such secretary?

  Determine the value of k

MATH1550H: Assignment:  Question:     Experience shows that X, the number of customers entering a post office during any period of time t, is a random variable the probability mass function of which is of the form

  What is the probability

MATH1550H: Assignment:Questions: (Genetics) What is the probability that at most two of the offspring are aa?

  Binomial distributions

MATH1550H: Assignment:  Questions:  Let’s assume the department of Mathematics of Trent University has 11 faculty members. For i = 0; 1; 2; 3; find pi, the probability that i of them were born on Canada Day using the binomial distributions.

  Caselet on mcdonald’s vs. burger king - waiting time

Caselet on McDonald’s vs. Burger King - Waiting time

  Generate descriptive statistics

Generate descriptive statistics. Create a stem-and-leaf plot of the data and box plot of the data.

  Sampling variability and standard error

Problems on Sampling Variability and Standard Error and Confidence Intervals

  Estimate the population mean

Estimate the population mean

  Conduct a marketing experiment

Conduct a marketing experiment in which students are to taste one of two different brands of soft drink

  Find out the probability

Find out the probability

  Linear programming models

LINEAR PROGRAMMING MODELS

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