Cholesterol level

Using Excel, evaluate the score that corresponds to 65 percentile in standard normal distribution. Put your result in cell A11.

by

Open the Excel program In our last computer assignment we learned how to find the standard normal distribution up to the given score value a, that is we found P(Z < a). We used Excel instead of the standard normal distribution table and evaluated P(Z<-1.72) with the command =NORMDIST(1.72,B1,B2,TRUE) and we obtained 0.042716 approximately. Here … Read more

Cholesterol level : Find out how genetically related the cholesterol level is, they measured the cholesterol level of eight mothers and their daughters. T

by

Cholesterol level Find out how genetically related the cholesterol level is, they measured the cholesterol level of eight mothers and their daughters. They obtained the following data. Mother  Her daughter 157                           154 189                           150 201                           184 174                           170 159                           158 213                           192 149                           143 143                           132 Evaluate the correlation coefficient and describe the correlation.