The following table shows the number of full-time faculty that WVU has on staff throughout the years. Year # of Faculty 2003 2007 2009 2013 1250 1290 1430 1470 2017 1540 2018 1650 (A) Find the equation of the regression line that represents the number of full-time faculty, y, as a function of x years since 2000. (round the regression coefficients to two decimal place y = (B) What is the correlation coefficient (r-value) for the regression model? (Round your answer to three decimal places) %3D (C) Given the value of r, does the regression line model the data well? That is, does the equation do a good job of modeling the data? O No, the r-value is high, meaning the data can't be modeled using a line O Yes, the r-value is high, meaning the data can be modeled using a line O No, the r-value is low, meaning the data can't be modeled using a line O Yes, the r-value is low, meaning the data can be modeled using a line

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
icon
Concept explainers
Question
The following table shows the number of full-time faculty that WVU has on staff throughout the years.
Year # of Faculty
2003
1250
2007
1290
2009
2013
1430
1470
2017
1540
2018
1650
(A) Find the equation of the regression line that represents the number of full-time faculty, y, as a function of x years since 2000. (round the regression coefficients to two decimal places)
y =
(B) What is the correlation coefficient (r-value) for the regression model? (Round your answer to three decimal places)
r =
(C) Given the value of r, does the regression line model the data well? That is, does the equation do a good job of modeling the data?
O No, the r-value is high, meaning the data can't be modeled using a line
O Yes, the r-value is high, meaning the data can be modeled using a line
No, the r-value is low, meaning the data can't be modeled using a line
O Yes, the r-value is low, meaning the data can be modeled using a line
(D) Using the regression line, How many Faculty members did WVU have in 2020? (Round your answer to the nearest whole number)
Transcribed Image Text:The following table shows the number of full-time faculty that WVU has on staff throughout the years. Year # of Faculty 2003 1250 2007 1290 2009 2013 1430 1470 2017 1540 2018 1650 (A) Find the equation of the regression line that represents the number of full-time faculty, y, as a function of x years since 2000. (round the regression coefficients to two decimal places) y = (B) What is the correlation coefficient (r-value) for the regression model? (Round your answer to three decimal places) r = (C) Given the value of r, does the regression line model the data well? That is, does the equation do a good job of modeling the data? O No, the r-value is high, meaning the data can't be modeled using a line O Yes, the r-value is high, meaning the data can be modeled using a line No, the r-value is low, meaning the data can't be modeled using a line O Yes, the r-value is low, meaning the data can be modeled using a line (D) Using the regression line, How many Faculty members did WVU have in 2020? (Round your answer to the nearest whole number)
Expert Solution
Step 1

(A)

 

 

Use EXCEL to obtain the regression equation.

 

EXCEL procedure:

 

  1. Go to EXCEL
  2. Go to Data>Data Analysis.
  3. Choose Regression.
  4. Input Y range as $B$1:$B$7.
  5. Input X range as $A$1:$A$7
  6. Check the option Labels in First row.
  7. Click OK.

 

EXCEL output:

 

Statistics homework question answer, step 1, image 1

 

trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Correlation, Regression, and Association
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman