# Project #18276 - Statistics 4

Use the worksheet attached (c3.0) and replicate the analysis given below in an excel spreadsheet. Use the worksheet attached and continue on that worksheet.

 Hospit ColumA Sex Colum B LOS ColumnC SST ColumnD SSWC Column E Average of LOS Sex Colum H Column I Column K Pivot table X X X X X Hospital Female Male Grand total SShosp X X X X X Alber X X X Xx X X X X X Beaufort X X X Xx X X X X X Catwba X X X Xx X X X X X Dare X X X xx X Xx X X X Grand total X X X X X X X X Ssex X1 X2 x X X X X X X X Xx X Xx X X X SSHosp*sex Sex X X X Xx X Hospital Female Male Grand total X X Xx X Albermarle Xxx Xxx X X X Xx X Beaufort Xxx Xxx Xxx xx X X x Catawba Xxx Xxx Xxx x Dare Xxx Xxx Xxx Grand Total xxx xxxx xxx SS df MS F Prob SShosp Xx Xx Xx Xx Ssex Xx Xx Xx Xx SShop*sex Xx Xx Xx xx SSWC Xx Xx xx SST xx xx

a.       Replicate a pivot table as shown in the top right

b.      Use this formula

q       m     n

SST= ∑                           Ξ

K=1  j=1     i=1    (x -  x  ) ²

Ijk

to calculate SST and input it into column D (where it says SST)

c.Use this formula

q       m     n

SSWC=

K=1  j=1     i=1    (x -  x? ) ²

Ijk     jk

to calculate SSWC and input it into column E

d.      Use this formula

q         Ξ

SSrows =  mn       (x?   - x )²

K=1      q

to calculate the SSrows (differences in hospitals) as shown in column K.

e.      Use this formula

Ξ

SScols = qn       (x?   -    x )²

J=1

to calculate SScols (differences between sexes)… where you find column H and x1

f.        Use this formula

q   m                        Ξ

SSrow.cols  = n ∑        (x?   -  x?   -  x?  + x )²

K=1  j=1

to calculate SS rows.cols (interaction between hospital and sex)…where you find column I and x2

Please show the functions/equations in excel.  Thanks!

 Subject Mathematics Due By (Pacific Time) 12/01/2013 06:00 pm
TutorRating
pallavi

Chat Now!

out of 1971 reviews
amosmm

Chat Now!

out of 766 reviews
PhyzKyd

Chat Now!

out of 1164 reviews
rajdeep77

Chat Now!

out of 721 reviews
sctys

Chat Now!

out of 1600 reviews

Chat Now!

out of 770 reviews
topnotcher

Chat Now!

out of 766 reviews
XXXIAO

Chat Now!

out of 680 reviews