Question

WORKSHEET HELP (STATS)

Answer 1

@amistre64

Answer 2

Ok, I have the line for 2 Part A....
y= .0414282822X + 19.38759909
Part B on #2 asks to graph the data on a scatter plot which I did in the link above ^^^ BUT it also asks to draw the regression line. Do I just plug in each # of pages for X to get the line???

Answer 3

(Actually generate the regression line. Do not just tick the box to create a
line)

i think that means it wants you to use the trendline feature in excel to draw the line in the scatter plot

Answer 4

im not sure how formal "tick the box" is .... its rather vague

Answer 5

or as you are prolly suggesting .... create a cell that will generate the plots for you maybe? but then youd have to include those cells in the scatter plot

Answer 6

I don't even know how to do that anyways....
i just drew out the scatter plot on the paper i'm writing my answers on and need to draw a regression line through the points

Answer 7

maybe just put the line in my graphing calc ??

Answer 8

i created an extra set of cells that define the pages by the slope and intercept of the regression line, then had it plot them in .. the red ones

Answer 9

to actually get the regression line, you have to go to:

chart tools
trendline
more trendline options
then pick linear and click show equation on graph

Answer 10

or, you can use the drawtool and line up 2 points ...

Answer 11

i dont see "chart tools" on there

Answer 12

click on the chart itself to get a tab called chart tools

Answer 13

o ok. i got it.

Answer 14

trendlines is under chart tools >> layout

so is the shapes option to draw a line

Answer 15

my line was drawn on its own when i clicked what you told me to click

Answer 16

yep :) which what i interpret "generate a line" to mean

Answer 17

...so you got the new points by plugging in the # of pages (or letting excel do that) into the linear equation?

Answer 18

part a is still incomplete. you have to develop the equation for the line.

i included what i would have done in the last excel a loaded up

Answer 19

i got the new points by creating a definition for the new line and inputing the given page values, yes

Answer 20

what do you mean part A is incomplete? it asks for the line and i have it.

Answer 21

it asks you to develop the line, and not have excel do it for you ....

in other words, combine your parts to show the equation of the regression line

Answer 22

\[(y-avgY)=m(x-avgX)\]
\[y=mx-m~avgX+avgY\]
\[y=mx+(-m~avgX+avgY)\]

Answer 23

id use 4 cells for that:

Answer 24

i used this link that Phi gave me to do #2 Part A
http://revisesmart.co.uk/maths/statistics-2/the-least-squares-regression-line.html

Answer 25

forgot the x :)