Use EXCEL to find the skewness and kurtosis values for the data in Fig. 5-1. If the variable
[ad_1]
4-6 Page Sociology Essay On Agents Of Socialization And Sociological Concepts Or TheoriesApril 26, 2021Defining Social Problems – Essay WritersApril 26, 2021Use EXCEL to find the skewness and kurtosis values for the data in Fig. 5-1. If the variable names are entered into A1:D1 and the sample data are entered into A2:D51 and any open cell is used to enter =SKEW(A2:A51) the value -0.0203 is returned. The function =SKEW(B2:B51) returns 1.9774, the function =SKEW(C2:C51) returns -1.4986, and =SKEW(D2:D51) returns 0.0156. The kurtosis values are obtained by =KURT(A2:A51) which gives -0.6083, =KURT(B2:B51) which gives 4.0985, =KURT(C2:C51) which gives 2.6368, and =KURT(D2:D51) which gives -1.1889. It can be seen that MINITAB and EXCEL give the same values for kurtosis and skewness. “Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!” “Is this question part of your assignment? We Can Help!”