Find the mean and standard deviation of the times and icicle lengths for the dat
ID: 3299001 • Letter: F
Question
Find the mean and standard deviation of the times and icicle lengths for the data on run 8903 in data data356.dat. Find the correlation between the two variables. Use these five numbers to find the equation of the regression line for predicting length from time. Use the same five numbers to find the equation of the regression line for predicting the time an icicle has been growing from its length (Round your answers to three decimal places.) times x = times s lengths x lengths s = time = ength length = timeExplanation / Answer
Times x bar=95
times s=53.385
lengths x bar=14.972
lengths s=9.465
r=corr coeff
Perform correlation ine xcel we get below ouput
r=0.996
Perform Regression in excel
length=-1.801+0.177(time)
Now perform Regression with length as independent variable
time=10.894+5.617(length)
slope=5.617
y intercept=10.894
time length Mean 95 Mean 14.97222 Standard Error 12.58306 Standard Error 2.230827 Median 95 Median 13.75 Mode #N/A Mode #N/A Standard Deviation 53.38539 Standard Deviation 9.464597 Sample Variance 2850 Sample Variance 89.57859 Kurtosis -1.2 Kurtosis -1.09672 Skewness -1.8E-16 Skewness 0.147361 Range 170 Range 31.3 Minimum 10 Minimum -0.1 Maximum 180 Maximum 31.2 Sum 1710 Sum 269.5 Count 18 Count 18 Confidence Level(95.0%) 26.54793 Confidence Level(95.0%) 4.706633Related Questions
Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.