Question

26. A lawn and garden centre intends to use sales of lawn fertilizer to predict lawn mower sales. The store manager wishes to determine the relationship between fertilizer and mower sales. The pertinent data are Number Number Fertilizer of SalesMowers Fertilizer of Sales Mowers Period (tonnes) Sold Perlod (tonnes) Sold 1.6 1.3 1.8 2.0 10 1.3 10 10 1.9 1.4 4 1.6 1.5 13 10 a. Determine the correlation between the two variables. Does it appear that a relationship between these variables will yield good predictions? Explain. (You may use ExcelsCORREL (RangeY,RangeX) to determine r, where RangeY is the range of Excel cells containing the y values and RangeX is the range of Excel cells containing the x values. You also need R2 RSQ(RangeYRangeX)) b. Obtain a linear regression line for the data. (You may use Excels =slope(RangeYRangeX) and -intercept(RangeYAangeX) to obtain the regression coefficients band a, respectively. Alternatively, use Trendline in the Layout menu.) c. Predict lawn mower sales, given fertilizer sales of 2 tonnes.

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Fertilizer #Mowers Period Sales sold 10 Correlation coefficient 0.960 0.921 R-squared 2.0 2.2 Remarks - high positive correla

Formulae used

A B Fertilizer # Mowers Period Sales sold 10 Correlation coefficient -CORREL(C3 C15,D3:D15) -RSQ(C3:C15,D3:D15) R-squared 4 2

Add a comment
Know the answer?
Add Answer to:
26. A lawn and garden centre intends to use sales of lawn fertilizer to predict lawn...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Height Fertilizer 20.4 1.9 29.1 5.0 28.2 4.2 24.3 1.3 29.2 4.9 29.8 5.4 34.6 3.1...

    Height Fertilizer 20.4 1.9 29.1 5.0 28.2 4.2 24.3 1.3 29.2 4.9 29.8 5.4 34.6 3.1 25.3 0.0 26.2 2.3 25.7 2.5 26.5 0.9 28.6 1.0 25.7 4.5 36.8 3.8 27.2 5.3 33.4 2.3 25.1 4.0 22.1 1.4 40.6 3.9 24.5 4.0 39.7 3.6 21.1 0.6 25.4 1.6 29.6 2.5 27.6 4.5 32.6 3.6 33.5 2.0 22.5 0.0 27.6 2.5 36.4 3.1 A horticulturist is studying the relationship between tomato plant height and fertilizer amount. Thirty tomato plants grown in...

  • All Greens is a franchise store that sells house plants and lawn and garden supplies. Although Al...

    All Greens is a franchise store that sells house plants and lawn and garden supplies. Although All Greens is a franchise, each store is owned and managed by private individuals. Some friends have asked you to go into business with them to open a new All Greens store in the suburbs of San Diego. The national franchise headquarters sent you the following information at your request. These data are about 27 All Greens stores in California. Each of the 27...

  • The manager of a seafood restaurant was asked to establish a pricing policy on lobster dinners....

    The manager of a seafood restaurant was asked to establish a pricing policy on lobster dinners. Experimenting with prices produced the following data Average number sold 158 159 154 134 131 129 118 113 114 105 Observation Price 6.00 6.50 6.75 7.00 7.25 7.75 8.00 8.25 8.50 8.75 9.00 9.25 2 3 4 6 7 8 9 10 12 79 a. Plot the graphfor the relationship between price and number of dinners sold. (Use scatter plot.) b. Determine the square...

  • Al Greens is a franchise store that sells house plants and lawn and garden supplies. Although...

    Al Greens is a franchise store that sells house plants and lawn and garden supplies. Although Al Greens is a franchise, each store is owned and managed by private individuals. Some friends have asked you to go into business with them to open a new All Greens store in the suburbs of San Diego. The national franchise headquarters sent you the following information at your request. These data are about 27 Al Greens stores in California. Each of the 27...

  • All Greens is a franchise store that sells house plants and lawn and garden supplies. Although All Greens is a franchise, each store is owned and managed by private individuals. Some friends have aske...

    All Greens is a franchise store that sells house plants and lawn and garden supplies. Although All Greens is a franchise, each store is owned and managed by private individuals. Some friends have asked you to go into business with them to open a new All Greens store in the suburbs of San Diego. The national franchise headquarters sent you the following information at your request. These data are about 27 All Greens stores in California. Each of the 27...

  • Based on the data collected by the sales manager in the Copier case, it appears that she would have some difficulty pre...

    Based on the data collected by the sales manager in the Copier case, it appears that she would have some difficulty predicting the sales based on only sales calls – especially at some levels of sales calls. For example, if one of her salespeople made between 70 and 80 calls, would she be able to predict a certain number of sales? Would it be easier to predict a range of sales? If yes, what would that range be?  Hint: Review...

  • # Part 3) PRICE 'ELASTICITY' (8 points) You are a financial manager for a unit within...

    # Part 3) PRICE 'ELASTICITY' (8 points) You are a financial manager for a unit within a textile company that specializes in zippers, buttons and other fasteners. Your area Vice President gives you the last 16 weeks of sales data for a recently launched product, the Elastiband 2.0 (units sold are in thousands). She asks you to analyze the data and provide a reliable sales forecast for the next four weeks. For your convenience, this data is provided in an...

  • Managers at the Turquoise Oasis Spa are interested in knowing whether there is a relationship between...

    Managers at the Turquoise Oasis Spa are interested in knowing whether there is a relationship between the age of their clients and the amount of money they spend in the spa. Upon analyzing the data, they found a correlation coefficient of .672. Thus, the relationship between the two variables is _________. strong moderate weak very weak Calculating the correlation coefficient using the_________ function is useful to determine the type and strength of a relationship between two variables. CAUSATION COVARIANCES CORREL...

  • Question 1: (24 marks) Because inflation reduces the purchasing power of the dollar, investors seek investments...

    Question 1: (24 marks) Because inflation reduces the purchasing power of the dollar, investors seek investments that will provide protection against inflation; that is, investments that will provide higher returns when inflation is higher. It is frequently stated that ordinary shares provide just such a hedge against inflation. The annual Australian inflation rate (as measured by percentage changes in the consumer price index) and the annual All-Ordinaries Index from 1995 to 2015 are stored in file INFLATION.XLSX. Using EXCEL, answer...

  • A recent article in BusinessWeek listed the “Best Small Companies.” We are interested in the relationship between the companies’ sales and earnings. A random sample of 12 companies wasselected and the...

    A recent article in BusinessWeek listed the “Best Small Companies.” We are interested in the relationship between the companies’ sales and earnings. A random sample of 12 companies wasselected and the sales and earnings, in millions of dollars, are reported below: Company Papa John’s InternationalApplied Innovation Integracare Wall Data Davidson & AssociatesChico’s FAS Checkmate Electronics Royal Grip M-Wave Serving-N-Slide Daig Cobra Golf Sales ($ millions) $29.2 18.6 18.2 71.7 58.6 46.8 17.5 11.9 19.6 51.2 28.6 69.2 Earnings ($ millions)...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT