Statistics students in Oxnard College sampled 9 textbooks in the Condor bookstore and recorded the number of pages in each textbook and its cost. The bivariate data are shown below: Number of Pages (xx) Cost(yy) 270 45.3 457 62.13 200 34 874 97.66 970 104.3 639 75.51 977 110.93 695 85.55 900 102 A student calculates a linear model yy = xx + . (Please show your answers to two decimal places) Use the model to estimate the cost when number of pages is 837. Cost = $ (Please show your answer to 2 decimal places.)
Statistics students in Oxnard College sampled 9 textbooks in the Condor bookstore and recorded the number of pages in each textbook and its cost. The bivariate data are shown below: Number of Pages (xx) Cost(yy) 270 45.3 457 62.13 200 34 874 97.66 970 104.3 639 75.51 977 110.93 695 85.55 900 102 A student calculates a linear model yy = xx + . (Please show your answers to two decimal places) Use the model to estimate the cost when number of pages is 837. Cost = $ (Please show your answer to 2 decimal places.)
MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
Related questions
Question
Statistics students in Oxnard College sampled 9 textbooks in the Condor bookstore and recorded the number of pages in each textbook and its cost. The bivariate data are shown below:
| Number of Pages (xx) | Cost(yy) |
|---|---|
| 270 | 45.3 |
| 457 | 62.13 |
| 200 | 34 |
| 874 | 97.66 |
| 970 | 104.3 |
| 639 | 75.51 |
| 977 | 110.93 |
| 695 | 85.55 |
| 900 | 102 |
A student calculates a linear model
yy = xx + . (Please show your answers to two decimal places)
Use the model to estimate the cost when number of pages is 837.
Cost = $ (Please show your answer to 2 decimal places.)
Expert Solution
Step 1
Step-by-step procedure to find the regression line using Excel:
- In Excel sheet, enter x and y in different columns.
- In Data, select Data Analysis and Choose Regression.
- In Input Y Range, select y.
- In Input X Range, select x.
- Click Labels in First Row.
- Click OK.
Step by step
Solved in 2 steps with 2 images
Recommended textbooks for you
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
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
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
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
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
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
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman