Answers to the Element Worksheet by znx55982

VIEWS: 105 PAGES: 11

More Info
									Paper Towel Project Instructions


      Use this data set to learn about analyzing data and making decisions.
      Save a copy of this file as your project file with a name you can remember.
      Consider which of these elements will make a difference in your selection of a paper towel to buy.

  1   The worksheet titled strength shows you the following data about six brands of paper towels:
      Consider which of these elements will make a difference in your selection of a paper towel to buy.
                 Brand                                         Absorbency Average (ml)
                 Average Strength (g)                          Absorbency Average per square centimeter (ml/sq.cm)
                 Strength Ratio Average (g/sq.cm)              Rate of Absorbency (sec)
      Analyze the strength data set and answer the questions on the strength worksheet.


  2   When you have finished working with the strength worksheet continue your analysis with the price worksheet.
      The worksheet titled price shows you the following data about the same six brands of paper towels:
      Consider which of these elements will make a difference in your selection of a paper towel to buy.
                 Cost per Roll (p)
                 Sheets per Roll (s)
                 Price per Sheet (p/s)
      Analyze the price data set and answer the questions on the price worksheet.


  3   When you have finished working with the price worksheet continue your analysis with the final worksheet.
      The worksheet titled final combines the data from the strength and price worksheets.
      Analyze this data set to make a final purchase decision by answering the questions on the final worksheet.
Strength Worksheet


     Brand       Average        Strength        Absorbency Absorbency     Rate of
                Strength (g)     Ratio          Average (ml)  Average   Absorbency
                                Average                      (ml/sq.cm)    (sec)
                               (g/sq.cm)
    Bounty          784.00        1.00                 85.50   0.15        35.00
   Brawny           475.33        0.48                 78.83   0.08        22.83
 Green Forest       475.33        0.48                 78.83   0.08        22.83
  RB (Local)        242.00        0.39                 39.00   0.06        18.83
 Scott Towels       502.00        0.74                 43.83   0.06        17.33
     Viva          1159.00        1.51                 84.33   0.11       112.50

              1 SORT the data by the data element you are interested in (e.g., sort Rate of Absorbency from lowest to highest)
                             Remember to select the entire chart when you sort so that the correct data remains with the Brand (range A2:F7
                             You may want to look at more than one element before you decide which paper towel to purchase.
              2 Create a bar or column chart for each data element you are interested in. (e.g., a chart for Average Strength)
                             Place the charts on this worksheet so you can compare them
                             You will have 5 charts if you analyze each element

              3 What do the charts tell you? Put your answers in the yellow boxes.
                          a. Which paper towel is the strongest?          Viva
                          b. Which paper towel is the weakest?          RB (Local)
                          c. Which paper towel absorbs the fastest? Scott Towels
                          d. Write another question that you could answer by analyzing the strength data.
                                            Which paper towel absorbs the most liquid?
                          e. Answer the question you wrote above.        Bounty

              4 Which paper towel will you purchase?       Bounty
                             Why?          I need my paper towels to be as absorbent as possible.

                                     Average Strength (g)                                      Absorbency Average (ml)



                  1400.00                                                   90.00
                                                                            80.00
                  1200.00
                                                                            70.00
                  1000.00
                                                                            60.00
                   800.00                                                   50.00

                   600.00                                                   40.00
                                                                            30.00
                   400.00
                                                                            20.00




File: 52f5733f-bc58-4c69-916f-b3f0a8971311.xls, Worksheet: 1 strength                                                                         Page 2
Strength Worksheet

                  400.00
                                                                                                                       20.00
                  200.00
                                                                                                                       10.00
                     0.00                                                                                               0.00

                            Bounty   Brawny   Green Forest   RB (Local)   Scott Towels     Viva                                   Bounty         Brawny   Green Forest   RB (Local)   Scott Towels   Viva




                                                                                                  Rate of Absorbency (sec)



                                                             120.00

                                                             100.00

                                                               80.00

                                                               60.00

                                                               40.00

                                                               20.00

                                                                0.00

                                                                           Bounty        Brawny      Green Forest    RB (Local)   Scott Towels     Viva




File: 52f5733f-bc58-4c69-916f-b3f0a8971311.xls, Worksheet: 1 strength                                                                                                                                       Page 3
Price Worksheet


     Brand        Cost per     Sheets       Price per
                  Roll (p)     per Roll      Sheet
                                 (s)          (p/s)
    Bounty        $     2.50     200           $0.013
   Brawny         $     1.99     175           $0.011
 Green Forest     $     2.75     150           $0.018
  RB (Local)      $     1.66     175           $0.009
 Scott Towels     $     2.25     225           $0.010
     Viva         $     2.25     150           $0.015

              1 SORT the data by a data element you are interested in. (e.g., sort Cost per Roll from lowest to highest)
                          You may want to look at more than one element before you decide which paper towel to purchase

              2 Create bar or column charts for the data elements (e.g., a chart for Cost per Roll)
                           Place the charts on this worksheet so you can compare them
                           You will have 3 charts if you analyze each element.

              3 What do the charts tell you? Put your answers in the yellow boxes.
                       a. Which paper towel is the cheapest?              RB (Local)
                       b. Which paper towel is the most expensive?        Green Forest
                       c. Which paper towel has the most sheets?          Scott Towels
                       d. Write another question that you could answer by analyzing the price data.
                                        Which paper towl costs the least per roll?
                       e. Answer the question you wrote above.            RB (Local)

              4 Which paper towel will you purchase?           RB (Local)
                          Why?         It is the cheapest per sheet and per unit, giving me savings on two levels.


                                          Cost per Roll (p)                                    Sheets per Roll (s)


                      $3.00                                                  250
                      $2.50
                                                                             200
                      $2.00
                      $1.50                                                  150
                      $1.00
                      $0.50                                                  100
                        $-                                                    50




File: 52f5733f-bc58-4c69-916f-b3f0a8971311.xls, Worksheet: 2 price                                                         Page 4
Price Worksheet


                                                                              0
                                                                                      Bounty   Brawny   Green      RB       Scott   Viva
                                                                                                        Forest   (Local)   Towels


                                                              Price per Sheet (p/s)


                                              $0.020
                                              $0.018
                                              $0.016
                                              $0.014
                                              $0.012
                                              $0.010
                                              $0.008
                                              $0.006
                                              $0.004
                                              $0.002
                                              $0.000




File: 52f5733f-bc58-4c69-916f-b3f0a8971311.xls, Worksheet: 2 price                                                                         Page 5
Final Worksheet


     Brand         Average        Strength   Absorbency Absorbency     Rate of          Cost per    Sheets      Price per
                  Strength (g)     Ratio     Average (ml) Average    Absorbency         Roll (p)    per Roll     Sheet
                                  Average                 (ml/sq.cm)    (sec)                         (s)         (p/s)
                                 (g/sq.cm)
    Bounty          784.00          1.00        85.50          0.15         35.00      $    2.50      200          $0.013
   Brawny           475.33          0.48        78.83          0.08         22.83      $    1.99      175          $0.011
 Green Forest       475.33          0.48        78.83          0.08         22.83      $    2.75      150          $0.018
  RB (Local)        242.00          0.39        39.00          0.06         18.83      $    1.66      175          $0.009
 Scott Towels       502.00          0.74        43.83          0.06         17.33      $    2.25      225          $0.010
     Viva          1159.00          1.51        84.33          0.11        112.50      $    2.25      150          $0.015


              1 From the strength analysis, which paper towel will you purchase for strength?      Bounty

              2 From the price analysis, which paper towel will you purchase for price?            RB (Local)

              3 Write three questions you want to answer about paper towels. Each question should include two of the data elements: price, strength, sheets per roll,
                              For example: Is there a paper towel that has a low cost per sheet and a high strength ratio average?
                              There are MANY other questions you could ask
                            1 Is there a paper towel that absorbs a lot of liquid but is not very expensive per sheet?                      (The cheapest towels we
                            2 Is there a paper towel that absorbs quickly but does not cost much per unit?                                  (Yes, RB is the least exp
                            3 Are stronger paper towels generally more expensive?                                                           (Generally yes, with the

              4 Choose the charts from the strength and price worksheets for the elements of strength and cost that you want to compare with each other based on y
                            Copy the charts from the strength and price worksheets to the final worksheet so you can compare them side by side

              5 It is often difficult to compare two elements that are measured differently.
                                 Create combination charts for analysis to help you answer your three questions.
                                 (Custom Type Chart - Line and Column on 2 axes)

              6 Which paper towel will you purchase?     RB (Local)
                             Why?          My analyses of the data show it will be the most affordable and still give me features I want.

              7 How did multiple analyses of the data elements help you make an informed decision?
                             The absorbency/cost per roll combination chart showed RB had the second-fastest absorbency rate and was the least expensive per unit
                             Though I like my paper towels to be absorbent, the speed coupled with price proved to be more important factors.




File: 52f5733f-bc58-4c69-916f-b3f0a8971311.xls, Worksheet: 3 final                                                                              Page 6
Final Worksheet




                                              Average Strength (g)                                                                  Absorbency Average (ml)                                                                 Rate of Absorbency (sec)



                  1400.00                                                                                 90.00                                                                                  120.00
                                                                                                          80.00
                  1200.00                                                                                                                                                                        100.00
                                                                                                          70.00
                  1000.00
                                                                                                          60.00                                                                                   80.00
                   800.00                                                                                 50.00
                                                                                                                                                                                                  60.00
                   600.00                                                                                 40.00
                                                                                                          30.00                                                                                   40.00
                   400.00
                                                                                                          20.00
                   200.00                                                                                                                                                                         20.00
                                                                                                          10.00
                     0.00                                                                                  0.00                                                                                    0.00

                            Bounty   Brawny     Green Forest    RB (Local)   Scott Towels   Viva                  Bounty   Brawny      Green Forest   RB (Local)   Scott Towels   Viva                    Bounty   Brawny      Green Forest




                                              Cost per Roll (p)                                                                      Price per Sheet (p/s)


                    $3.00                                                                                    $0.020
                                                                                                             $0.018
                    $2.50                                                                                    $0.016
                    $2.00                                                                                    $0.014
                                                                                                             $0.012
                    $1.50                                                                                    $0.010
                                                                                                             $0.008
                    $1.00                                                                                    $0.006
                    $0.50                                                                                    $0.004
                                                                                                             $0.002
                      $-                                                                                     $0.000




                  0.16                                                $0.020                                               120.00                                                        $3.00
                  0.14                                                $0.018
                                                                      $0.016                       Absorbency              100.00                                                        $2.50               Rate of
                  0.12                                                $0.014                       Average                  80.00                                                        $2.00               Absorbency
                  0.10                                                $0.012                       (ml/sq.cm)                                                                                                (sec)
                  0.08                                                $0.010                                                60.00                                                        $1.50
                  0.06                                                $0.008                       Price per Sheet                                                                                           Cost per Roll
                                                                      $0.006                       (p/s)                    40.00                                                        $1.00               (p)
                  0.04                                                $0.004
                  0.02                                                                                                      20.00                                                        $0.50
                                                                      $0.002
                  0.00                                                $0.000                                                  0.00                                                       $-


File: 52f5733f-bc58-4c69-916f-b3f0a8971311.xls, Worksheet: 3 final                                                                                                                                                     Page 7
Final Worksheet

                                                  $0.002
                  0.00                            $0.000             0.00                      $-




                                             1400.00                  $0.020
                                                                      $0.018
                                             1200.00
                                                                      $0.016
                                             1000.00                  $0.014
                                              800.00                  $0.012   Average Strength (g)
                                                                      $0.010
                                              600.00                  $0.008   Price per Sheet (p/s)
                                              400.00                  $0.006
                                                                      $0.004
                                              200.00
                                                                      $0.002
                                                 0.00                 $0.000




File: 52f5733f-bc58-4c69-916f-b3f0a8971311.xls, Worksheet: 3 final                                     Page 8
              Final Worksheet




  strength, sheets per roll, absorbency, etc.


  (The cheapest towels were also the least absorbent.)
  (Yes, RB is the least expensive and second-fastest absorbing.)
  (Generally yes, with the exception of Green Forest)

with each other based on your three questions.




 e least expensive per unit




              File: 52f5733f-bc58-4c69-916f-b3f0a8971311.xls, Worksheet: 3 final   Page 9
          Final Worksheet




Rate of Absorbency (sec)




   Green Forest    RB (Local)   Scott Towels   Viva




          File: 52f5733f-bc58-4c69-916f-b3f0a8971311.xls, Worksheet: 3 final   Page 10
Final Worksheet




File: 52f5733f-bc58-4c69-916f-b3f0a8971311.xls, Worksheet: 3 final   Page 11

								
To top