Sailing ♒ Name:

Table one
SailboatLength (m)
Optimist2.34
Bug2.60
Taz2.95
Topper3.40
Laser Pico3.50
Vibe3.80
Topaz3.86
Funboat3.90
Magno3.94
Laser4.20
Sunfish4.24
Laser 20004.44

The length of several small sailboats are listed in table one. Use the lengths to answer the following questions.

Data sheet

Part I: Basic Statistics

  1. __________ What is the level of measurement for the data in table one?
  2. n = __________ Calculate the sample size n.
  3. __________ Calculate the minimum.
  4. __________ Calculate the maximum.
  5. __________ Calculate the range.
  6. __________ Calculate the midrange.
  7. __________ Calculate the mode.
  8. __________ Calculate the median.
  9. x = __________ Calculate the sample mean x.
  10. sx = __________ Calculate the sample standard deviation sx.
  11. __________ Calculate the coefficient of variation.
  12. _________ Determine the class width. Use 3 classes (bins or intervals).
  13. Fill in the following frequency table:
    Classes (x)Frequency fRel Freq p(x)
    Sums:
  14. Sketch a histogram of the frequency data to the right of the table.
  15. __________________ What is the shape of the distribution?
  16. __________ Using the sample mean and standard deviation from table one calculate the z-score for a hull with a length of 4.44 meters.
  17. __________ Is the z-score for a 4.44 meter hull ordinary or extraordinary?
  18. SE = _________ Calculate the standard error of the sample mean x
  19. tcritical = _________ Calculate tcritical for a confidence level c of 95%
  20. E = _________ Calculate the margin of error E for the sample mean x.
  21. Write out the 95% confidence interval for the population mean μ
    p(_____________ < μ < ___________) = 0.95

    Run a hypothesis test for whether the data in table one could have a population mean hull length of 4 meters. at an alpha α of 0.05.
    H0: μ = 4
    H1: μ ≠ 4
  22. tcritical = _________ Calculate tcritical at α = 0.05.
  23. t = _________ Calculate the t-statistic t.
  24. p-value = _________ Calculate the p-value.
  25. max c = _________ Calculate the maximum confidence that the data in table one has a population mean hull length of 4 meters.
  26. _____________________ At an alpha α of 5%, would you fail to reject |or| reject the null hypothesis?

    Part II: Hypothesis Testing using the t-test

    Topper sailboats are manufactured with a transom mounted mainsheet. The Topper can be converted to a center mounted mainsheet, a system often used in larger racing boats. The hypothesis that a Topper with a transom mounted mainsheet is faster than a Topper with a center mounted mainsheet was tested. Note that the mainsheet is a line which attaches to the boom of the mainsail.

    Ten topper sailboats were divided into two groups of five each, one group with transom mounted mainsheets and one group with centre mounted mainsheets. The data is race time in seconds for a single race. Lower times are faster.

    The data is NOT paired data, the samples are independent.

    Topper
    Table two
    Topper mainsheet trials
    CenterTransom
    12841200
    12741253
    13471229
    12891244
    13651279
  27. _________ Calculate the sample mean center mounted mainsheet system time
  28. _________ Calculate the sample mean transom mounted mainsheet system time
  29. _________ Are the sample means for the two samples arithmetically different?
  30. __________________ What is the p-value? Use the TTEST function with two tails to determine the p-value for these two independent samples.
  31. __________________ Is the difference in the means statistically significant at an alpha α = 0.05?
  32. __________________ Would we fail to reject | or | reject a null hypothesis of no difference in the sample means?
  33. _____________ What is the maximum level of confidence we can have that the difference is statistically significant?


    Part III: Linear Regression (best fit or least squares line)
    Hull length versus hull speed background rectangle major grid lines axes x-axis and y-axis linear regression line data points as circles text layers Hull length versus hull speed Length (m) Hull speed (kph) y-axis labels 6.9 7.2 7.4 7.7 7.9 8.2 8.4 8.7 9.0 9.2 9.5 x-axis labels 2.4 2.6 2.8 3.0 3.2 3.4 3.6 3.8 4.0 4.2 4.4
    Table three
    Length (m)Hull speed (kph)
    2.356.90
    2.957.73
    3.408.30
    3.868.84
    3.948.93
    3.808.77
    4.209.22
    3.508.42
    2.607.26
    4.249.27
    3.908.89
    4.449.48

    The data in the table provides the estimated hull speed for a sailboat based on the hull length. The first column is the hull length in meters. The second column is the estimated hull speed in kilometers per hour.
  34. _________ Calculate the slope of the linear regression (best fit line).
  35. _________ Calculate the y-intercept of the linear regression (best fit line).
  36. _________ Is the relation positive, negative, or neutral?
  37. _________ Calculate the linear correlation coefficient r for the data.
  38. ______________ Is the correlation none, weak/low, moderate, strong/high, or perfect?
  39. ______________ Determine the coefficient of determination.
  40. ______________ What percent variation in length "explains" the variation in hull speed?
  41. ___________ Use the slope and intercept above to predict the hull speed for a 3.5 meter hull length.
  42. ___________ Use the slope and intercept above to predict the hull length needed to for a hull speed of 8 kilometers per hour.

Data sources:
Topper sailboats
Laser International
Transom vs center mount data, © Jim Champ, December 16th 2002, 2007



n 12
min 2.34
max 4.44
range 2.1
midrange 3.39
mode #VALUE!
median 3.83
mean 3.6
stdev 0.66
cv 0.18
classes 3
width 0.7
cul f rf
3.04 3 0.25
3.74 2 0.17
4.44 7 0.58
5.14 0 0
5.84 0 0
6.54 0 0
7.24 0 0
12

SE0.19
tc 2.2
E0.42
lower 3.18
upper 4.02
mean 3.6
pop mean4
t-2.1
p-value0.06

Part II
Center Transom
n 5 5
mean 1311.8 1241
stdev 41.2 29.25
ttest 0.01591 

y = 1.23331x + 4.062

count 12
slope:  1.23
intercept:  4.06
correl:  0.99906
coef det 0.99812
y given x 8.38
x given y 3.19
ttest:  72.83
p-value:  0.0000000 Probably have to omit this due to values.
max c 1.0000000