# Project #18081 - Statistics 1

1.       Use the data on the  worksheet c.10 (attached) and replicate the data with equations shown below

 hospital costs (C-Xbarbar)^2 (C-Xbar^2) Alberm Xxx Xxx Xxxx Average of Costs Xxx Xxxx Xxxx Xxxxxx Hospital Total Nj*(Xbar-Xbarbar)^2 Xxxx Xxxxx Xxxx Xxxxx Alber Xxx Xxx Xxxx Xxx Xxx Xxxxxx Beaufort Xxx Xxx Xxx Xxx Xxxxx Xxxxxxxx Catawba Xx Xxxx Xxx Xxxxx Xxxxx Xxxxxx Dare Xxx xxx Xxx Xxxx Xxx Xxxx Grand total xxx xxx Xxxxx Xxx Xxxx Xxx Xxxx Xxx xxx SS Df MS F       P Xxx Xxx Xxx Xxx SST Xxxx Xxx Xxx X       x Xxx Xxx Xxx Xxx SSB Xxxxx Xxx Xxx Xxx Xxx Xxx Xxx SSW xxxx xxx xxx xxx Xxx xxxxxx xxx

a.       Use a pivot table to and this formula     SSB =  m

nj (?xj - x?)²

j= 1

to calculate the between group of squares (SSB) for the costs of four hospitals

b.      Use the results of the pivot table from (a) and this formula

SSw =  m      nj

(x  - ?x) ²

j=1  i-1      ij     j

to calculate the within group sums of squares (SSw) for the costs in the four hospitals

c.       Use this formula

SST =  m      nj

(x  - x?) ²

j=1       i=1     ij    j

To calculate the total sums of quares (SST) for the costs in the four hospitals

d.      Determine the appropriate degrees of freedom and use the this formula

F= SS? /dfss?  =  MS?

SSSw/dfssw      MSw

To calculate the F value for a test of the null hypothesis that the mean costs in the four hospitals are all the same

e.      Use the =FDIST () function to obtain the probability of the f value and draw the appropriate conclusion in regard to the null hypothesis

Please show the equation functions in excel.  Please use excel for this. Thanks!

 Subject Mathematics Due By (Pacific Time) 11/29/2013 08: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