Question

The table below show data that has been collected from different fields from various farms in a certain valley. The table contains the grams of Raspberries tested and the amount of their Vitamin C content in mg. Find a linear model that express Vitamin C content as a function of the weight of the Raspberries.

grams	Vitamin C content in mg
70	18.7
85	25.3
100	32.6
115	39.1
130	45.5
145	51.2
160	58.4

A) Find the regression equation: y=

x+

Round your answers to 3 decimal places

B) Answer the following questions using your un-rounded regression equation.  

If we test 190 grams of raspberries what is the expected Vitamin C content? mg

(round to the nearest tenth)

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

A) y=0.438x-11.640

B) If x=190

then ,  y=0.438(190)-11.640

=71.6

If we test 190 grams of raspberries then the expected Vitamin C content = 71.6 mg