Question

Generic algebra help needed

Answer 1

@UsukiDoll @jim_thompson5910

Answer 2

what spreadsheet program do you have?

Answer 3

I have google spreadsheets but this is straight from my school

Answer 4

ok let me try something

Answer 5

kk

Answer 6

start by typing in the given data into google spreadsheets

Answer 7

okay

Answer 8

now in another blank empty cell, type

=CORREL(

then you can highlight each row one at a time
separate the rows by a comma

Answer 9

IT Doesnt work

Answer 10

do you have the numbers in row 1 spanning from B2 to K2 ?

Answer 11

yeah I never wrote the title to the rows

Answer 12

sorry I meant B1 to K1

Answer 13

ok so you go from A1 to J1

Answer 14

yup and i hvae b2 to k2

Answer 15

if you ignore the titles

Answer 16

yup never wrote the titles

Answer 17

This is what I have (see attached)

I then typed in the formula

=Correl( B2:K2, B1:K1)

into an empty cell

Answer 18

oh you forgot the inside of the () thats why it didn't work

Answer 19

There are 2 chunks of data

the first group is B2:K2 which means "everything from B2 to K2"
the second group is B1:K1

Answer 20

this is what i got

Answer 21

you only need to do it once

Answer 22

0.97 is the approximate correlation

Answer 23

okay

Answer 24

@jim_thompson5910

Answer 25

what's your question?

Answer 26

is the answer B?

Answer 27

yeah 0.97

Answer 28

yasssss