Peace Valley Boat Rental Statistics - McNelis

Document Sample
Peace Valley Boat Rental Statistics - McNelis Powered By Docstoc
					Bill Reilly
Dan Park
Peace Valley Boat Rental
 Opens first Saturday
  of May every year
 Closes in mid October
 Offers moorings,
  permits, lessons,
  programs, and boat
  rentals including:
       Single/double kayaks
       Paddleboats
       Canoes
       Aquafins
       Daysailors
       Rowboats
Purpose
   To see if Saturdays or Sundays are
    busier during the season
     Test the total amount of boats rented out for
      30 Saturdays and 30 Sundays
     Test the total amount of cash/charge made
      for the day
     Hypothesis: Sundays are busier than
      Saturdays
Procedure and Data Collection
   60 total summary sheets were collected
    from the Bucks County Department of
    Parks and Recreation located at 510
    Creek Road, New Britain Township
     Summary sheets contain the total amount of
     boats rented out for a given day and the
     total amount of money made, cash and
     charge amounts
Procedure and Data Collection
   Dates, total rentals,
    and total profits for
    the 30 Saturdays
    and Sundays were
    recorded in Fathom
   Exploratory Analysis
    includes histograms,
    charts, and
    summaries
Procedure and Data Collection
   Tests:
     2 Sample T-Tests
      ○ Comparing total average profits between
        Saturday and Sunday
      ○ Comparing average number of boat rentals
        between Saturday and Sunday
     Confidence Intervals for both tests
Data
Sunday
          Date      Day       TotalCa...   TotalRe ...   <ne w >
  units          DateTime
    1            06/28/2009     1970.52           157
    2            08/09/2009      427.18            34
    3            10/04/2009      844.82            64
    4            10/11/2009      361.46            29
    5            05/31/2009     1398.14           118
    6            06/21/2009      598.90            52
    7            08/31/2008     3034.78           202
    8            05/10/2009      408.10            38
    9            05/17/2009         0.00             0
   10            06/07/2009     2191.02           163
   11            06/14/2009     1351.02            96
   12            06/17/2007     2279.00           154
   13            05/03/2009      321.18            29
   14            07/05/2009     2625.62           187
   15            07/12/2009     2220.70           182
   16            09/13/2009     1227.48            98
   17            07/15/2007     2625.62           187
   18            09/21/2008      957.18            71
   19            10/12/2008      809.84            64
   20            09/28/2008       13.78              1
   21            09/14/2008      800.30            62
   22            09/20/2009      402.80            32
   23            06/10/2007      870.26            66
   24            08/30/3009     2115.20           145
   25            08/16/2009     1358.64            97
   26            07/19/2009     2943.62           194
   27            09/27/2009         0.00             0
   28            05/24/2009     2436.94           186
   29            10/05/2008      273.48            22
   30            10/18/2008      174.32            18
Data
Saturday
           Date      Day       TotalCa...         e
                                            TotalR ...   <ne w >
  units           DateTime
    1             08/15/2009     1601.10          123
    2             09/19/2009     1125.72            86
    3             10/03/2009         0.00            0
    4             10/10/2009         0.00            0
    5             07/18/2009     2680.96          170
    6             06/16/2007     1621.82          104
    7             07/25/2009     2228.25          153
    8             05/09/2009      843.30            39
    9             06/06/2009     1357.48            77
   10             05/16/2009      419.24            18
   11             06/13/2009      661.98            37
   12             06/02/2007      941.28            76
   13             05/23/2009     1882.56          130
   14             07/11/2009     1852.88          129
   15             07/04/2009     2466.62          184
   16             06/26/2009     1336.66          106
   17             05/30/2009      981.59            71
   18             06/09/2007      993.22            80
   19             09/26/2009      175.96            12
   20             09/05/2009     2779.32          222
   21             08/29/2009      504.56            44
   22             08/11/2007     1089.98          140
   23             08/18/2007     1631.34          139
   24             10/04/2008      229.42            14
   25             09/27/2008       31.80             3
   26             09/20/2008      652.96            49
   27             08/30/2008     1033.50            77
   28             09/13/2008      617.98            47
   29             06/23/2007     1631.82          107
   30             05/30/2009      962.26            80
Exploratory Data Analysis
Saturday Total Profit
                   Saturday


                                        1144.52
                                             0
                                         617.98
                   TotalCashChargeSat   1013.36
                                        1631.34
                                        2779.32
                                        777.846
                   S1   =   mean
                   S2   =   min
                   S3   =   Q1
                   S4   =   median
                   S5   =   Q3
                   S6   =   max
                   S7   =   s
Exploratory Data Analysis
Saturday Total Profit
 Shape: Somewhat normal
 Center:1144.52
 Spread: Gaps, (0, 2779.32)
 The Peace Valley Park Boat Rentals has
  a profit range of $0 to $2779.32 on
  Saturdays
 The Peace Valley Park Boat Rentals
  makes an average profit of $1144.52 on
  every Saturdays
Exploratory Data Analysis
Saturday Total Boat Rentals
                   Saturday


                                       83.9
                                         0
                                        39
                   TotalRentalsSat     78.5
                                       129
                                       222
                                     58.234
                   S1   =   mean
                   S2   =   min
                   S3   =   Q1
                   S4   =   median
                   S5   =   Q3
                   S6   =   max
                   S7   =   s
Exploratory Data Analysis
Saturday Total Boat Rentals
 Shape: Right Skew
 Center:83.9
 Spread: (0, 58.234) Gaps
 The Peace Valley Park Boat Rentals has
  a boat rental range from 0 to 58 boats
  on Saturdays
 The Peace Valley Park Boat Rentals
  rents 84 boats on average on Saturdays
Exploratory Data Analysis
Sunday Total Profit
                   Sunday


                                        1234.73
                                             0
                                          402.8
                   TotalCashChargeSun    913.72
                                        2191.02
                                        3034.78
                                        967.984
                   S1 =   mean
                   S2 =   min
                   S3 =   Q1
                   S4 =   median
                   S5 =   Q3
                   S6 =   max
                   S7 =   s
Exploratory Data Analysis
SundayTotal Profit
 Shape: Approximately normal
 Center:1243.73
 Spread: Gaps, (0, 3034.78)
 The Peace Valley Park Boat Rentals has
  a profit range of $0 to $3034.74 on
  Sundays.
 The Peace Valley Park Boat Rentals
  makes an average profit of $1243.73 on
  every Sundays
Exploratory Data Analysis
Sunday Total Boat Rentals
                    Sunday


                                        91.6
                                          0
                                         32
                    TotalRentalSun      68.5
                                        157
                                        202
                                     67.6566
                   S1   =   mean
                   S2   =   min
                   S3   =   Q1
                   S4   =   median
                   S5   =   Q3
                   S6   =   max
                   S7   =   s
Exploratory Data Analysis
Sunday Total Boat Rentals
 Shape: Slight Right Skew or
  Approximately Normal
 Center:91.6
 Spread: (0, 67.657) Gaps
 The Peace Valley Park Boat Rentals has
  a boat rental range from 0 to 68boats on
  Sundays
 The Peace Valley Park Boat Rentals
  rents 92 boats on average on Sundays
Assumptions for 2 Sample T-Test
and Confidence Intervals
   Assumption
     SRS
     2 Independent Normal Population or n1 and
     n2 is greater or equal to 30
   Check
     The data was randomized by a
      software(Calculator)
     n1 and n2 is equal to 30
 sat   sun
      




         2 Sample T-Test #1
            Comparing average profit made
             between Saturday and Sunday
            Hypothesis
            Ho
                 sat   sun
               Ha
                 sat   sun
2 Sample T-Test #1

          x
   t =       = -0.3979
          s
            n
   P(t<-0.3979|df=56) = 0.3461
2 Sample T-Test #1
   Conclusions
     We fail to reject Ho because P-value is
      greater than
     We have sufficient evidence that the
      average total cash made on Saturday is
      equal to the average total cash made on
      Sunday
2 Sample T-Confidence Interval
#1
    ( xsat  xsun )  t * (s / n )
   (-544.5, 364.06)
 We are 95% confident that the
  difference of average total cash made
  on Saturday and Sunday is between
  -544.50 and 364.06 dollars.
 The interval contains 0. Therefore, the
  test is correct that it shows that there is
  no difference between Saturday and
  Sunday.
2 Sample T-Test #2
 Comparing the average total boats
  rented between Saturday and Sunday
 Hypothesis
 Ho
     sat   sun
   Ha
     sat   sun
2 Sample T-Test #2

          x
   t =       = -0.4725
          s
            n
   P(t<-0.4725|df=56) = 0.3192
2 Sample T-Test #2
   Conclusions
     We fail to reject Ho because P-value is
      greater than
     We have sufficient evidence that the
      average total boat rentals made on
      Saturday is equal to the average total
      boats rented on Sunday
2 Sample T-Confidence Interval
#2
    ( xsat  xsun )  t * (s / n )
 (-40.34,    24,94)
 We are 95% confident that the difference of
  average total boat rentals made on
  Saturday and Sunday is between -40.34
  and 24.94 Boats.
 The interval contains 0. Therefore, the test
  is correct that it shows that there is no
  difference between Saturday and Sunday.
Application
 Peace Valley Park Boat Rentals make
  the same average amount of profit on
  Saturday and Sunday
 Peace Valley Park Boat Rentals rent out
  the same amount of average boats on
  Saturday and Sunday.
Bias/Errors
 Incomplete or inaccurate records
 Weather not taken into consideration
     Considerably less people rent boats when
     the weather is bad
   Not completely random
     Not all records available
   Does not only rent boats
     It sells boat permits and moorings
Personal Opinions/Conclusions
   I thought the project was overall hard and
    tedious
   It was very surprising to find out that the
    average profits and the average total boats
    rented out on Saturday and Sunday were the
    same. We thought Sunday would be busier
   I think more time would have been better,
    especially for our topic because there were a
    lot of papers that we had to go through
   Overall the project was a good learning
    experience about the Peace Valley Park Boat
    Renting Place and its business

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:2
posted:11/6/2012
language:English
pages:28