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 data are shown below:

)
465	51.2
711	80.88
536	67.88
347	46.76
720	67.6
248	35.84
909	80.72
735	81.8
579	70.32

A student calculates a linear model using technology (Statistics Calculator or Computer)
ˆy = x + . (Please show your answers to two decimal places)
Use the model to estimate the cost when number of pages is 932.
Cost = $ (Use the linear model with yor rounded coefficients and then round your answer to 2 decimal places.)

Answer 1

We can use here Excel for regression equation

Step 1) Enter data in Excel .

Step 2) Data >>Data analysis >>Regression >>Select y and x values separately >>Ok

if x=932

=87.16

Therefore, estimated cost = $87.16 when number of pages is 932