Ask your own question, for FREE!
Mathematics 14 Online
OpenStudy (anonymous):

Gonna need help with this worksheet...

OpenStudy (anonymous):

OpenStudy (anonymous):

ok here's the formula for simple regression: Y=B0+B1*X+E and here's the formula for multiple regression: Y=B0+B1*X1+B2*X2+.....Bk*Xk+E

OpenStudy (anonymous):

Can someone start me off with #1 part a?

OpenStudy (anonymous):

@amistre64 @phi @satellite73

OpenStudy (anonymous):

@.Sam. @jhonyy9 @lalaly @LoveYou*69 @Luis_Rivera @Mertsj @tomo

OpenStudy (anonymous):

i have no idea how to do a least squares, or any statistics really. sorry

OpenStudy (anonymous):

:(

OpenStudy (anonymous):

it's kinda like slope y=b+mx ...regression is: y=b0+b1x

OpenStudy (anonymous):

AMISTRE!!!!!!!!!!!!!!!!!!!!!! :DDD

OpenStudy (amistre64):

well, one thing i know off thebat is that the anchor point for the line will be the average x and average y values

OpenStudy (amistre64):

do you recall all the Sxx Sxy stuff? if not i can look it up to refresh

OpenStudy (anonymous):

ditto. im just having a hard time setting up the data so it fits the regression equation. for example, which regression equation should i use (simple or multiple)? and what do i put for B0?

OpenStudy (anonymous):

what does Sxx and Sxy stand for again?

OpenStudy (amistre64):

if i walk myself thru it ... they are something in the back of my head for standard errors i think

OpenStudy (amistre64):

we want a line mx+b, such that it is the average of all the stated points, or rather that the distance squared, from the line to any given point is a minimum

OpenStudy (anonymous):

i have SSE (sum of squares for erros) in my notes and SE (standard error of estimate)

OpenStudy (amistre64):

those look useful

OpenStudy (anonymous):

i also have the coefficient of determination (R^2)

OpenStudy (amistre64):

http://stattrek.com/regression/linear-regression.aspx thats the site i was looking for

OpenStudy (anonymous):

hold on, im gonna upload some notes i took

OpenStudy (amistre64):

anchor point is: \((\bar x,\bar y)\) \[b_1=\frac{\sum[(x_i-\bar x)(y_i-\bar y)}{\sum(x_i-\bar x)}\] so b1 is the slope and the given anchor point can be inputed into the point slope format of a line

OpenStudy (amistre64):

forgot a square on the denominator

OpenStudy (anonymous):

ok, nevermind about posting notes. cant get them on my computer.

OpenStudy (amistre64):

Hours studied 2 4 5 8 10 11; avg = 6' 2/3 Exam Score 50 67 75 90 95 99 ; avg = 79' 1/3

OpenStudy (amistre64):

2-6-2/3 = -4 2/3 4-6-2/3 = -2 2/3 5-6-2/3 = -1 2/3 8-6-2/3 = 1 1/3 10-6-2/3 = 3 1/3 11-6-2/3 = 4 1/3 50-79-1/3 = -29 1/3 67-79-1/3 = -12 1/3 75-79-1/3 = -4 1/3 90-79-1/3 = 11 2/3 95-79-1/3 = 16 2/3 99-79-1/3 = 20 2/3 ((-4- 2/3)(-29- 1/3)+(-2- 2/3)(-12- 1/3)+(-1- 2/3)(-4- 1/3)+(1+ 1/3)(11+ 2/3)+(3+ 1/3)(16+ 2/3)+(4+1/3)(20+ 2/3))\((-4- 2/3)+(-2- 2/3)+(-1- 2/3)+(1+ 1/3)+(3+ 1/3)+(4+1/3)) the wolf hates me .....

OpenStudy (anonymous):

wouldn't the 2 (xi-xbar)'s cancel out?

OpenStudy (amistre64):

no, a sum over a sum does not cancel out like summands

OpenStudy (amistre64):

\[\frac{a+b}{a+c}\ne\frac{b}{c}\]

OpenStudy (amistre64):

umm, hours is "x" parts right?

OpenStudy (anonymous):

yup

OpenStudy (amistre64):

2 4 5 8 10 11; avg = 6' 2/3 6 12 15 24 30 33 -20 ------------------- -4 -8 -5 4 10 13 10/3 = sum (x-bar x) then

OpenStudy (anonymous):

i have a question about the denominator. in the numerator we multiply to get the answer, but there's nothing to multiply by in the denominator, so do i just add up the answers i got for each x given subtracted by x bar?

OpenStudy (anonymous):

o nvm i think you just answered my question ha ^^

OpenStudy (amistre64):

-4/3 -8/3 -5/3 4/3 10/3 13/3 50 67 75 90 95 99 ; avg = 79' 1/3 150 201 225 270 285 351 -237 -------------------------- -87 -36 -12 33 48 114 -4/3( -87/3)-8/3(-36/3)-5/3( -12/3)+4/3( 33/3)+10/3( 48/3)+13/3(114/3) = 310 3(310)/10 = 3(31) = 93 as a slope?

OpenStudy (anonymous):

6 12 15 24 30 33 -20 150 201 225 270 285 351 -237 where do these #s come from??

OpenStudy (amistre64):

when adding or subtracting fractions, its best to multiply the whole number by the denominator, in this case that was 3 .... then you can do some normal subtracting 6 2/3 = 20/3

OpenStudy (amistre64):

the slope should be about 5.2 .....

OpenStudy (anonymous):

alright hold on a second. im gonna write all this out on paper and see how you got everything.

OpenStudy (amistre64):

i forgot to square the demoninator

OpenStudy (anonymous):

like always ;)

OpenStudy (amistre64):

i went and let Excel do the work .... but i organized the data into what was needed

OpenStudy (anonymous):

-4 -8 -5 4 10 13 ...so these are all the answers you get when multiplying the numerators together? -87 -36 -12 33 48 114 and ....these are all the answers when adding the denominators together?

OpenStudy (amistre64):

4 things needed for the linear regression line average X average Y sum of the products sum of the xs squared \[Line:~y-avgY=\frac{sum~of~products}{sum~of~xs}(x-avgX)\]

OpenStudy (amistre64):

by hand i got a value of 10/3 .. without squareing it :) so denominator is 100/9

OpenStudy (amistre64):

pfft, still confused .....

OpenStudy (amistre64):

2 4 5 8 10 11; avg = 6' 2/3 6 12 15 24 30 33 -20 ------------------- -14 -8 -5 4 10 13 , square these then add (196+64+25+16+100+169) / 9 ... since 3^2 = 9 196 169 164 25 16 ---- 570 570/9 = 63 1/3

OpenStudy (amistre64):

im not even going to attempt a product of the xy parts by hand lol

OpenStudy (anonymous):

lol hold on im working it out on paper...

OpenStudy (anonymous):

ok, i must be doing something wrong... i got (300.8) / (4) when i multiplied everything in the numerator and added in the denominator

OpenStudy (amistre64):

\[top:~(x_1-\bar x)(y_1-\bar y)+(x_2-\bar x)(y_2-\bar y)+(x_3-\bar x)(y_3-\bar y)\\~ \\~~~~~~~~~~~~~~+(x_4-\bar x)(y_4-\bar y)+(x_5-\bar x)(y_5-\bar y)+(x_6-\bar x)(y_6-\bar y)\] your top is worked out like this right?

OpenStudy (anonymous):

ok, lemme type out what i wrote out...

OpenStudy (anonymous):

( (-4&2/3 * -29&1/3) + (-2&2/3 * -12&1/3) + (-1&2/3 * -4&1/3) + (1&1/3 * 11&2/3) + ( 3&1/3 * 16&2/3) + (4&1/3 * 20&2/3) ) // ( (-4&2/3) + (-2&2/3) + (-1&2/3) + (1&1/3) + (3&1/3) + (4&1/3)

OpenStudy (anonymous):

( ( -10/3) * -86/3) + (-4/3 * -35/3) + (-1/3 * -11/3) + (4/3 * 35/3) + (10/3 * 50/2) + (13/3 * 62/3) ) is what i did to the numerator first before multiplying and adding it

OpenStudy (amistre64):

this worksheet says your allowed to use excel, but just not in configuring the linear regression equation ..... in other words, no letting excee process the final result. right?

OpenStudy (anonymous):

im assuming he just wants us to show our work.

OpenStudy (amistre64):

lol, there is a difference between showing work, and torturing yourself.

OpenStudy (anonymous):

its a handwritten assignment that we turn in class.

OpenStudy (amistre64):

then it torture ...

OpenStudy (anonymous):

YES, that class IS torture! ha

OpenStudy (anonymous):

ok so what am i doing wrong

OpenStudy (anonymous):

i used a graphing calc to input everything to get the answers i got

OpenStudy (amistre64):

\[top:~(\frac{6-20}{3})(\frac{150-238}{3})+(\frac{12-20}{3})(\frac{201-238}{3})+(\frac{15-20}{3})(\frac{225-238}{3})\\~ \\~~~~~~~~~~~~~~+(\frac{24-20}{3})(\frac{270-238}{3})+(\frac{30-20}{3})(\frac{285-238}{3})+(\frac{33-20}{3})(\frac{297-238}{3})\] \[bottom:~(\frac{6-20}{3})^2+(\frac{12-20}{3})^2+(\frac{15-20}{3})^2\\~ \\~~~~~~~~~~~~~~+(\frac{24-20}{3})^2+(\frac{30-20}{3})^2+(\frac{33-20}{3})^2\]

OpenStudy (anonymous):

ok i didnt square each individual answer on the bottom... but for the top you dont get 300.8? want me to put it in my calc?

OpenStudy (amistre64):

i get what i got on the excel picture i posted :)

OpenStudy (amistre64):

for the top i get 328.67

OpenStudy (anonymous):

thats lazy ;)

OpenStudy (amistre64):

i know ... but im old

OpenStudy (anonymous):

excuses excuses lol

OpenStudy (amistre64):

you are close to it, so im sure there is just some input error in your calculator

OpenStudy (anonymous):

i think i see it.....

OpenStudy (anonymous):

ok i still got the wrong answer so ill just do it the way you did it... i dont know why im getting the wrong answer doing it my way

OpenStudy (amistre64):

..cause my way is ALWAYS best ;)

OpenStudy (amistre64):

\[top:~(\frac{-14(-88)}{9})+(\frac{-8(-37)}{9})+(\frac{-5(-13)}{9})\\~ \\~~~~~~~~~~~~~~+(\frac{4(32)}{9})+(\frac{10(47)}{9})+(\frac{13(59)}{9})\] \[top:~\frac{-14(-88)-8(-37)-5(-13)+4(32)+10(47)+13(59)}{9}\] \[top:~\frac{1232+296+65+128+470+767}{9}\] \[top:~\frac{2958}{9}=328.66666.....\]

OpenStudy (amistre64):

this was fun, but i gotta get going home now. enjoy ;)

OpenStudy (anonymous):

yeah, it was "fun" lol talk to you later.

OpenStudy (anonymous):

For #1 Part B it asks what will happen if you studied 30 more minutes... so do I just plug in .5 or 1/2 to the line equation? y=5.1895x + 44.737

OpenStudy (anonymous):

@phi

OpenStudy (phi):

almost. all you care about is the slope you want the change in y (how many more points) with a change in x (hours studied)

OpenStudy (phi):

so you do not care about the 44.737

OpenStudy (anonymous):

so just plug in .5 for x and multiply by the slope?

OpenStudy (phi):

Part B it asks what will happen if you studied 30 more minutes. It is like asking, "if you move 1/2 hour on the x-axis, how far up to you move on the y-axis?"

OpenStudy (phi):

yes

OpenStudy (anonymous):

ok sounds good. thanks. i'll let you know when i need more help.

OpenStudy (phi):

fyi, I checked your numbers y=5.1895x + 44.737 and they look good

OpenStudy (anonymous):

ok so i got 21.07921567 for the standard error of estimate for Part E but I dont know how to explain if the model fits well with the data.

OpenStudy (anonymous):

i'm also needing help with Part F and for #2, do I basically do the same thing I did for #1 Part A first? i'm gonna logoff, but please do continue to help if you're online and i'm not. I will log on sooner than later to see what you say. thanks. :)

OpenStudy (phi):

** i got 21.07921567 for the standard error of estimate for Part E** How did you get this number? According to wikipedia the standard error squared is \[\sigma^2= \sum\frac{\epsilon \epsilon }{n-p} \] n is the number of samples and p is 2 (# of parameters) the residual error is the difference between the data and the least-square estimate 50 67 75 90 95 99 55.1158 65.4947 70.6842 86.2526 96.6316 101.8211 just looking at the plot, you can see it is a good fit.

OpenStudy (anonymous):

wait, how did you get the #s below the test scores again?

OpenStudy (anonymous):

@amistre64

OpenStudy (amistre64):

#2 is the same concepts as #1, just a new set of numbers

OpenStudy (amistre64):

pages relate to X, and prices to Y

OpenStudy (anonymous):

im still working on #1 haha (parts e and f) i was wondering where Phi got the #s underneath the test scores ^^^

OpenStudy (amistre64):

im not sure what phis method was. youll have to consult the phi :)

OpenStudy (anonymous):

can you help me finish parts e and f then? i have the error of estimate for e but i need to explain whether the model fits the data well. for part f i have an idea of what to do but im not 100% sure. do i draw a standard normal curve?

Can't find your answer? Make a FREE account and ask your own questions, OR help others and earn volunteer hours!

Join our real-time social learning platform and learn together with your friends!
Latest Questions
AsianPanda08: What should i eat for dinner tonight? I can't choose
44 minutes ago 51 Replies 2 Medals
Nina001: Trying 2 figure out what is the square root of 8746685
1 hour ago 23 Replies 2 Medals
SnowyBreaks: Is it bad to lose 3.8 pounds in less than 2 days?
44 minutes ago 42 Replies 0 Medals
kaelynw: tried a lil smt, the arm is off but i like the other stuff
4 hours ago 8 Replies 2 Medals
laylasnii13: Who wanna write or make a song with me???
4 hours ago 8 Replies 0 Medals
kaelynw: art igg
12 hours ago 13 Replies 2 Medals
XShawtyX: Art
1 day ago 6 Replies 0 Medals
Can't find your answer? Make a FREE account and ask your own questions, OR help others and earn volunteer hours!

Join our real-time social learning platform and learn together with your friends!