# Answers to the Element Worksheet by znx55982

VIEWS: 105 PAGES: 11

• pg 1
```									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.
(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