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
Report DMCA
TutorRating
pallavi

Chat Now!

out of 1971 reviews
More..
amosmm

Chat Now!

out of 766 reviews
More..
PhyzKyd

Chat Now!

out of 1164 reviews
More..
rajdeep77

Chat Now!

out of 721 reviews
More..
sctys

Chat Now!

out of 1600 reviews
More..
sharadgreen

Chat Now!

out of 770 reviews
More..
topnotcher

Chat Now!

out of 766 reviews
More..
XXXIAO

Chat Now!

out of 680 reviews
More..
All Rights Reserved. Copyright by AceMyHW.com - Copyright Policy