Question

In: Statistics and Probability

There are two variables in this data set. Variable Definition Height Height in inches Weight Weight...

There are two variables in this data set.

Variable Definition

Height Height in inches

Weight Weight in pounds

Using Excel, compute the standard deviation and variance (both biased and unbiased) for height and weight.

Height weight
53 156
46 131
54 123
44 142
56 156
76 171
87 143
65 135
45 138
44 114
57 154
68 166
65 153
66 140
54 143
66 156
51 173
58 143
49 161
48 131

Solutions

Expert Solution

In Excel, insert the data and apply the given formulas shown in the screenshot below:

The results are:

Height weight
Biased SD 11.1463 15.2561
Biased Variance 124.24 232.748
Unbiased SD 11.4359 15.6524
Unbaised Variance 130.779 244.997

orchestra answered 1 year ago
Next > < Previous

Related Solutions

The data set is height in inches and weight in pounds of random patients at the...
The data set is height in inches and weight in pounds of random patients at the Dr's office. Predict the weight of a patient that is 67 inches tall. Is it possible to predict using linear regression? Support your answer Linear regression was completed with the following results: Equation: Weight = -281.847 + 6.335*Height p-value = 0.00161 Height Weight 68 148 69 126 66 145 70 158 66 140 68 126 64 120 66 119 70 182 62 127 68...
The following data was collected on the height (inches) and weight (pounds) of women swimmers. Height...
The following data was collected on the height (inches) and weight (pounds) of women swimmers. Height Weight 68 132 64 108 62 102 65 115 66 128 Provide a regression analysis from the height and weight data. SUMMARY OUTPUT Regression Statistics Multiple R 0.9603 R Square 0.9223 Adjusted R Square 0.8963 Standard Error 4.1231 Observations 5 ANOVA df SS MS F Significance F Regression 1 605 605 35.5882 0.0094 Residual 3 51 17 Total 4 656 Coefficients Standard Error t...
calculate the BMi. weight 138lb, height 5ft and 5 inches
calculate the BMi. weight 138lb, height 5ft and 5 inches
You are given a data set containing the height, weight, age, and blood pressure of a...
You are given a data set containing the height, weight, age, and blood pressure of a representative sample of people from a major metropolitan area. Comment on the suitability of using a statistically-based versus a cluster-based outlier detection scheme to identify people with anomalous characteristics for this data set.   
Language C++ Ask the user to enter their weight (in pounds) and their height in inches....
Language C++ Ask the user to enter their weight (in pounds) and their height in inches. Calculate their Body Mass Index (BMI) and tell them whether they are underweight, overweight, or at optimal weight. BMI formula: weight * 703 / (height * height) Optimal weight is a BMI from 19 to 26. Lower is underweight, higher is overweight. Prompts: Enter your weight (in pounds): [possible user input: 144] Enter your height (in inches): [posible user input: 73] Possible Outputs: Your...
The PulseRates data set has pulse, height and weight for 90 patients who had an echocardiogram...
The PulseRates data set has pulse, height and weight for 90 patients who had an echocardiogram test in one of the clinic in Ottawa in the month of September. (a)[2] Fit a L-S regression line using height to predict the pulse rate (pulse rate is called the response variable). What is the equation of the L-S regression line? . Does it make sense to use this line? Why? (Check the correlation coefficient) (b)[2] Fit a L-S regression line using weight...
The data set cherry.csv, from Hand et al. (1994), contains measurements of diameter (inches), height (feet),...
The data set cherry.csv, from Hand et al. (1994), contains measurements of diameter (inches), height (feet), and timber volume (cubic feet) for a sample of 31 black cherry trees. Diameter and height of trees are easily measured, but volume is more difficult to measure. (i) Suppose that these trees are a SRS from a forest of N = 2967 trees and that the sum of the diameters for all trees in the forest is tx = 41835 inches. Use ratio...
Student What is your height in inches? What is your weight in pounds? What is your...
Student What is your height in inches? What is your weight in pounds? What is your cumulative Grade Point Average (GPA) at FTCC or your primary college? How many hours do you sleep each night? 1 67 100 4 7 2 62 105 4 5 3 72 120 4 8 4 61 125 4 7 5 56 105 3.7 6 6 61 120 4 7 7 65 172 3.8 7 8 72 235 3.22 5 9 63 135 4 6...
Student What is your height in inches? What is your weight in pounds? What is your...
Student What is your height in inches? What is your weight in pounds? What is your cumulative Grade Point Average (GPA) at FTCC or your primary college? How many hours do you sleep each night? 1 67 100 4 7 2 62 105 4 5 3 72 120 4 8 4 61 125 4 7 5 56 105 3.7 6 6 61 120 4 7 7 65 172 3.8 7 8 72 235 3.22 5 9 63 135 4 6...
1-A regression analysis between weight (y in pounds) and height (x in inches) resulted in the...
1-A regression analysis between weight (y in pounds) and height (x in inches) resulted in the following least squares line: ?̂=120+5? This implies that if the height is increased by 1 inch, the weight is expected to: A. increase by 5 pounds B. increase by 24 pounds C. increase by 1 pound D. decrease by 1 pound If the coefficient of correlation is -0.60, then the coefficient of determination is: A. 0.36 B. -0.36 C. -0.60 D. 0.40 2- For...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT