A community for students.
Here's the question you clicked on:
 0 viewing
bobobox
 one year ago
Generic algebra help needed
bobobox
 one year ago
Generic algebra help needed

This Question is Closed

bobobox
 one year ago
Best ResponseYou've already chosen the best response.0@UsukiDoll @jim_thompson5910

jim_thompson5910
 one year ago
Best ResponseYou've already chosen the best response.0what spreadsheet program do you have?

bobobox
 one year ago
Best ResponseYou've already chosen the best response.0I have google spreadsheets but this is straight from my school

jim_thompson5910
 one year ago
Best ResponseYou've already chosen the best response.0ok let me try something

jim_thompson5910
 one year ago
Best ResponseYou've already chosen the best response.0start by typing in the given data into google spreadsheets

jim_thompson5910
 one year ago
Best ResponseYou've already chosen the best response.0now in another blank empty cell, type =CORREL( then you can highlight each row one at a time separate the rows by a comma

jim_thompson5910
 one year ago
Best ResponseYou've already chosen the best response.0do you have the numbers in row 1 spanning from B2 to K2 ?

bobobox
 one year ago
Best ResponseYou've already chosen the best response.0yeah I never wrote the title to the rows

jim_thompson5910
 one year ago
Best ResponseYou've already chosen the best response.0sorry I meant B1 to K1

jim_thompson5910
 one year ago
Best ResponseYou've already chosen the best response.0ok so you go from A1 to J1

bobobox
 one year ago
Best ResponseYou've already chosen the best response.0yup and i hvae b2 to k2

jim_thompson5910
 one year ago
Best ResponseYou've already chosen the best response.0if you ignore the titles

bobobox
 one year ago
Best ResponseYou've already chosen the best response.0yup never wrote the titles

jim_thompson5910
 one year ago
Best ResponseYou've already chosen the best response.0This is what I have (see attached) I then typed in the formula =Correl( B2:K2, B1:K1) into an empty cell

bobobox
 one year ago
Best ResponseYou've already chosen the best response.0oh you forgot the inside of the () thats why it didn't work

jim_thompson5910
 one year ago
Best ResponseYou've already chosen the best response.0There are 2 chunks of data the first group is B2:K2 which means "everything from B2 to K2" the second group is B1:K1

jim_thompson5910
 one year ago
Best ResponseYou've already chosen the best response.0you only need to do it once

jim_thompson5910
 one year ago
Best ResponseYou've already chosen the best response.00.97 is the approximate correlation

jim_thompson5910
 one year ago
Best ResponseYou've already chosen the best response.0what's your question?
Ask your own question
Sign UpFind more explanations on OpenStudy
Your question is ready. Sign up for free to start getting answers.
spraguer
(Moderator)
5
→ View Detailed Profile
is replying to Can someone tell me what button the professor is hitting...
23
 Teamwork 19 Teammate
 Problem Solving 19 Hero
 Engagement 19 Mad Hatter
 You have blocked this person.
 ✔ You're a fan Checking fan status...
Thanks for being so helpful in mathematics. If you are getting quality help, make sure you spread the word about OpenStudy.