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