How to input LinReg eq to find predicted values of X and Ys?

bugmenot · 08-21-2009, 06:02 PM

Hey I'm currently enrolled in a regular Stats course for college and this is my first time using Excel. How do I properly input my LinReg eq into Excel to have it compute all of my predicted values?

I got my eq by inputting a scatterplot of my X and Ys and right clicking on a point and adding trendline and selecting the option to show the equation.

Any help would be greatly appreciated, thanks!

\1

**zbor** · 08-22-2009, 07:29 AM

Where from did you get equation? From same table (B and C column)?

Then prediction is same as input...

Also, please upload workbook you made screenshot of. Don't need whole workbook, just copy-paste values into new sheet and upload it. Also hide all important data.
But it's unfair to expect that all who trying to give you solution has to re-type all data from your jpg.
Someone will lose half hour to retype it and 5 minutes to give you solution.

**zbor** · 08-22-2009, 07:34 AM

As far as you write here you can make =number1 * B10 - number2

bugmenot · 08-22-2009, 03:35 PM

Hey, I got the equation linear regression line of the B and C table. I right clicked on a point on my scatterplot then clicked on Add Trendline then clicked the box to show the equation on my chart. I think I did everything correctly but I'm not too sure.

I just did it entered = 0.0039189795 * B10 - 2006.8785774275 in the box and it seemed to do the job. I then dragged the bottom right corner down all the way.

Can you please check to see if my work was done properly?
Thanks for the help zbor

I uploaded my datasheet, sorry for not thinking about it earlier

**zbor** · 08-22-2009, 03:41 PM

You can also do this:

=TREND($C$10:$C$60;$B$10:$B$60;B10)

and extend down.

This is better way because you can change values and your result change then too.

(replace ; with , if needed)

bugmenot · 08-22-2009, 05:45 PM

oh wow ok thanks a lot

I got the equation part, does everything else seem accurate? If you are have any spare time can you please double check my work because I have no one else to refer to my school's tutoring dept is closed due to budget cuts in California and my teacher said he isn't going to review anything. He said we can sit there and work with a TI83 if we don't know how to use excel.

Thanks a lot man you've been a great help!