Questions
The table below shows the scores of 25 Mathematics students in two mid-term tests and the...

The table below shows the scores of 25 Mathematics students in two mid-term tests and the Final test score.

Test 1 Test 2 Final Test
75 69 76
95 75 93
91 78 90
98 84 98
75 57 71
54 39 51
71 63 75
48 48 58
89 68 88
81 60 82
71 60 71
72 56 71
95 81 92
81 69 76
72 63 74
95 76 96
80 64 74
83 77 92
90 79 89
80 71 80
84 74 89
88 70 88
80 71 88
78 71 75
98 80 96

Tasks:

  • Perform multiple linear regression analysis using Microsoft Excel, assuming final test score as the dependent variable and test 1 and test 2 scores as independent variables.
  • Correctly state the regression equation.
  • Evaluate the significance of the regression fit for the data.
  • Determine if the regression coefficients are significant.
  • Check if independent variables are collinear.
  • Comment on the residual plots.
  • Use the regression equation to predict final score for
    • test 1 score = 82, and
    • test 2 score = 69

Submission Details:

  • Submit a 3–4 page Microsoft Word document, using APA style.
  • The relevant Excel output should be copied to this document.

In: Statistics and Probability

Period Demand F1 F2 1 68 65 62 2 75 65 65 3 70 74 70...

Period Demand F1 F2
1 68 65 62
2 75 65 65
3 70 74 70
4 74 69 71
5 69 72 76
6 72 68 74
7 80 73 75
8 78 75 82

        

a.

Calculate the Mean Absolute Deviation for F1 and F2. Which is more accurate? (Round your answers to 2 decimal places.)

        

  MAD F1   
  MAD F2   

         

    (Click to select)F1F2None appears to be more accurate.

        

b.

Calculate the Mean Squared Error for F1 and F2. Which is more accurate? (Round your answers to 2 decimal places.)

        

  MSE F1   
  MSE F2   

        

  (Click to select)F2F1None appears to be more accurate.

         

c.

You can choose which forecast is more accurate, by calculating these two error methods. When would you use MAD? When would you us MSE?

Hint: Control charts are related to MSE; tracking signals are related to MAD.

        

Either one might already be in use, familiar to users, and have past values for comparison. If (Click to select)control chartstracking signals are used, MSE would be natural; if (Click to select)tracking signalscontrol charts are used, MAD would be more natura

        

d.

Calculate the Mean Absolute Percent Error for F1 and F2. Which is more accurate? (Round your intermediate calculations to 2 decimal places and and final answers to 2 decimal places.)

         

  MAPE F1   
  MAPE F2   

       

  (Click to select)F1F2None appears to be more accurate.

In: Operations Management

Suppose John grows $1 million in peanuts and sells them to Snappy's which uses them to...

Suppose John grows $1 million in peanuts and sells them to Snappy's which uses them to make $5 million in peanut butter. These two actions contribute _____ to GDP.

Group of answer choices

$5 million

$1 million

$4 million

$6 million

In: Economics

The growth of China’s economy may not be sustainable due to imbalances in China’s economy, according...

The growth of China’s economy may not be sustainable due to imbalances in China’s economy, according to Lardy what are the major imbalances China faces?

Kroeber believes this problem is overstated. Why?

According to Lardy, and Kroeber, does a low level of social welfare spending contribute to these imbalances?

In: Economics

1. Discuss how factors relating to biological and age-related risks, environmental risks, and behavioral risks contribute...

1. Discuss how factors relating to biological and age-related risks, environmental risks, and behavioral risks contribute to family health and the achievement of healthy outcomes.

2. Discuss activities that the nurse practicing in the community can implement to assist families to decrease health risks.

In: Nursing

Many cases of severe combined immunodeficiency disease (SCID) are caused by the lack of the enzyme...

Many cases of severe combined immunodeficiency disease (SCID) are caused by the lack of the enzyme adenosine deaminase (ADA).

a. What pathway normally contains the enzyme ADA?

b. How does the absence of ADA contribute to the non-functional immune system observed in SCID patients?

In: Biology

What are the different types of budgets in a master budget? Why is it important to...

What are the different types of budgets in a master budget?
Why is it important to get the figures for a budget as ‘accurate’ as possible? Or, indeed, is it important?
How do relevant costs and revenues contribute to sound decision making?
What types of costs and revenues are relevant to decision making? Why?

In: Accounting

This discussion forum explores ways Americans exploited the native societies.(need 150 words) In what ways did...

This discussion forum explores ways Americans exploited the native societies.(need 150 words)

  • In what ways did the settlers contribute to the exploitation of Native Americans?
  • Did the economic benefit of white westward expansion justify Native American exploitation? Justify your answer.

In: Economics

No plagiarizing please ”1. Explain the digestion that occurs in the oral cavity.” ”2. What is...

No plagiarizing please

”1. Explain the digestion that occurs in the oral cavity.”

”2. What is the function of the liver in digestion? ”

”3. What role does the gallbladder play in digestion? ”

4. Why is the orientation of the muscle of the stomach wall important? How does this contribute to its function?

In: Anatomy and Physiology

explain how the following processes each contribute to animal development: regional specification, cell differentiation, morphogenesis, growth,...

explain how the following processes each contribute to animal development: regional specification, cell differentiation, morphogenesis, growth, and developmental time (also known as temporal control). Use citations from peer-reviewed scientific journal articles or the textbook to support your ideas.

In: Biology