# Simple regression using excel and interpreting the results

Not what you're looking for?

See the attachment.

1. The quality of the orange juice produced by a manufacturer (e.g., Minute Maid, Tropicana) is constantly monitored. There are numerous sensory and chemical components that combine to make the best-tasting orange juice. For example, one manufacturer has developed a quantitative index of the "sweetness" of orange juice. (The higher the index, the sweeter the juice.) Is there a relationship between the sweetness index and a chemical measure such as the amount of water-soluble pectin (parts per million) in the orange juice? Data collected on these two variables for 24 production runs at a juice manufacturing plant are shown in the table below. Suppose a manufacturer wants to use simple linear regression to predict the sweetness (y) from the amount of pectin (x).

Run Sweetness Index Pectin (ppm) Run Sweetness Index Pectin (ppm)

1 5.2 220 13 5.8 306

2 5.5 227 14 5.5 259

3 6 259 15 5.3 284

4 5.9 210 16 5.3 383

5 5.8 224 17 5.7 271

6 6 215 18 5.5 264

7 5.8 231 19 5.7 227

8 5.6 268 20 5.3 263

9 5.6 239 21 5.9 232

10 5.9 212 22 5.8 220

11 5.4 410 23 5.8 246

12 5.6 256 24 5.9 241

Please assist with the following:

a. Find the least squares line for the data.

b. What do β0 and β1 represent in the words of the problem?

c. Predict the sweetness index if amount of pectin in the orange juice is 300 ppm.

d. Find the values of SSE, s2, and s for this regression.

e. Explain why it is difficult to give a practical interpretation to s2.

f. Give a practical interpretation of the value of s.

g. Use the results of the regression to form a 95% confidence interval for the slope, b1.

h. Find and interpret the coefficient of determination, r2, and the coefficient of correlation, r.

i. A 90% confidence interval for the predicted value of mean sweetness index, E(y), for run 1 is (5.649,5.838). What does this interval mean in terms of the problem?

##### Purchase this Solution

##### Solution Summary

The solution gives detailed steps on running a simple regression using Excel and interpreting the results such as least squares line, slope, coefficient of determination and standard error.

##### Solution Preview

See the attached files.

1. The quality of the orange juice produced by a manufacturer (e.g., Minute Maid, Tropicana) is constantly monitored. There are numerous sensory and chemical components that combine to make the best-tasting orange juice. For example, one manufacturer has developed a quantitative index of the "sweetness" of orange juice. (The higher the index, the sweeter the juice.) Is there a relationship between the sweetness index and a chemical measure such as the amount of water-soluble pectin (parts per million) in the orange juice? Data collected on these two variables for 24 production runs at a juice manufacturing plant are shown in the table below. Suppose a manufacturer wants to use simple linear regression to predict the sweetness ...

##### Purchase this Solution

##### Free BrainMass Quizzes

##### 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.

##### 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.

##### Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

##### Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.