Regression analysis
Not what you're looking for?
You are the manager of the PSC marina on the Missouri River. From observations in the past, you think there is a direct link between the river level and the amount of fuel you sell. As the level rises, your sales increase, and as it decreases, your sales decline. The owner of the marina just took a statistics class at Peru State College, and believes that linear regression is the key to predicting sales. She has given you the task of developing this equation. As a reference, please see both your text and the Excel Tutor 9.1. Take special note of the fact that the data tools are not installed until used the first time. You need to present a well written memo to the owner (Ms. Sunny). Please use a memo template in Word, and paste in the appropriate charts and data. Explain all data to Ms. Sunny, as her grade in the statistics class was not very good
River Level Gallons of Gasoline Sold
12.1 2046
13.2 2111
13.5 2214
14.2 2460
15 2640
15.4 2710
16.2 2924
16.7 3090
17.1 3332
17.2 3460
17.4 3671
17.5 3712
Use regression analysis to calculate the line that best fits relationship between the river level and the sale of gasoline. This is the y= 11.5441+19.63241X . Examine the Excel tutor for where these numbers are derived from. Then use that equation to calculate what the sales will be at a river level of 15.8 and a level of 16.3. Finally, explain to your boss the implications of using this regression model if heavy rains cause the river to rise above 18 feet.
Purchase this Solution
Solution Summary
It applies regression analysis to calculate the line that best fits relationship between the river level and the sale of gasoline.
Solution Preview
Please see the attached file.
The R-square value, which indicates the goodness of fit for the regression line is The R-square value, which indicates the goodness of fit for the regression line is The R-square value, which indicates the goodness of fit for the regression ...
Purchase this Solution
Free BrainMass Quizzes
Terms and Definitions for Statistics
This quiz covers basic terms and definitions of statistics.
Measures of Central Tendency
Tests knowledge of the three main measures of central tendency, including some simple calculation questions.
Measures of Central Tendency
This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.
Know Your Statistical Concepts
Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.