Statistics help for my university child

Kristy Cathro

New Member
Joined
Feb 25, 2016
Messages
5
Hi,

I am of NO help to my daughter who is doing a Bachelor of Business studies. She has come home with statistics homework and the only thing I could do to help was create a pivot table. Please can you help us and me to explain how to do the following tasks.

Question 1 below, I have done what I thought was correct. Question 2 below; I have no idea how to help. Can you help me please?

Thanks
Kristy

This is the data she was given.

CaratColourClarityLabPrice(US$1000)
0.52HVVS1DHC2.191
0.56FVS2DHC2.2414
0.57FVS2DHC2.2792
0.52EVS2DHC2.3422
0.57HVVS1DHC2.3905
0.6GVS2DHC2.3947
0.5GVVS1DHC2.4024
0.55GVVS2DHC2.4703
0.62IVVS2DHC2.5305
0.61HVVS2DHC2.5312
0.65IVVS2DHC2.5501
0.56FVS1DHC2.5669
0.53FVVS2DHC2.5907
0.5FVVS1DHC2.6446
0.64HVVS2DHC2.6495
0.58HIFDHC2.6544
0.51FVVS1DHC2.6957
0.6HVVS1DHC2.7475
0.6GVS1DHC2.7475
0.53FVVS1DHC2.7965
0.66HVVS1DHC3.01
0.7HVS2DHC3.0422
0.71HVVS2DHC3.6351
0.73FVS2DHC3.7331
0.7GVVS2DHC3.857
0.72HVVS1DHC3.9634
0.7GVVS1DHC4.06
0.74HVVS1DHC4.0705
0.86HVS2DHC4.0845
0.73GVVS1DHC4.2287
0.8HVS1DHC4.2357
0.7EVVS2DHC4.3995
0.71GIFDHC4.4604
0.8HVVS2DHC4.4912
0.81GVS1DHC4.5465
0.82FVS2DHC4.6004
0.85FVS2DHC4.7635
0.7EVVS1DHC4.8069
0.8GVVS2DHC4.8335
0.8FVS1DHC4.8335
0.81FVS1DHC4.8916
0.81EVS2DHC4.8916
0.82GVVS2DHC4.9504
0.81HIFDHC5.1506
0.85GVVS1DHC5.3977
1IVS2DHC5.4726
1IVS1DHC5.6665
1.01IVS1DHC5.7225
0.85FVVS1DHC5.8513
1IVVS2DHC5.8604
0.8FIFDHC6.0277
0.81EVVS1DHC6.1005
1IVVS1DHC6.1516
1HVS2DHC6.1516
1.01IVVS1DHC6.2111
1.02HVS2DHC6.2713
1HVS1DHC6.3455
1.09IVVS2DHC6.3749
1.01HVS1DHC6.4071
1GVS2DHC6.4421
1.01GVS2DHC6.5051
1.01HVVS2DHC6.6031
1HVVS1DHC6.636
1.06HVVS2DHC6.923
1GVVS2DHC6.9272
1.01GVVS2DHC6.9951
1.01FVS1DHC7.1904
1GVVS1DHC7.315
1FVVS2DHC7.4116
1EVS1DHC7.4116
1.01EVS1DHC7.4844
1.02FVVS2DHC7.5572
1EVVS2DHC7.9933
1.01EVVS2DHC8.0717
1FVVS1DHC8.1872
1.01FVVS1DHC8.2677
1DVVS2DHC9.6425
1.01DVVS2DHC9.7363
1EVVS1DHC9.8357
0.33IVS2GEM0.7686
0.31IVS1GEM0.7882
0.31HVS2GEM0.7882
0.32GVS2GEM0.8414
0.34HVS2GEM0.8554
0.35HVS2GEM0.8785
0.3GVS1GEM0.882
0.34GVS2GEM0.8883
0.3DVS2GEM0.9114
0.34HVS1GEM0.9212
0.33EVS2GEM0.9289
0.34GVS1GEM0.987
0.37HVS1GEM0.994
0.37FVS2GEM0.994
0.31GVVS2GEM0.9989
0.31FVS1GEM0.9989
0.35GVS1GEM1.0129
0.32FVS1GEM1.0276
0.36HVVS2GEM1.0395
0.3GVVS1GEM1.057
0.3EVS1GEM1.057
0.4HVS1GEM1.0675
0.34FVS1GEM1.0857
0.31EVS1GEM1.0885
0.45IVS1GEM1.1004
0.35FVS1GEM1.1151
0.36FVS1GEM1.1445
0.31DVS1GEM1.1487
0.34EVS1GEM1.1851
0.35EVS1GEM1.2166
0.43HVVS2GEM1.2229
0.4FVS1GEM1.3377
0.41FVS1GEM1.3692
0.48GVVS2GEM1.7724
0.56IVVS2GEM2.0244
0.46EVVS2GEM2.0594
0.5GVS1GEM2.1112
0.51GVS1GEM2.2435
0.5FVS1GEM2.3051
0.53GVVS2GEM2.3849
0.57HVVS1GEM2.3905
0.52FVS1GEM2.3926
0.5GVVS1GEM2.4024
0.53FVS1GEM2.436
0.52DVS2GEM2.443
0.5FVVS2GEM2.4507
0.5EVS1GEM2.4507
0.5EVS1GEM2.4507
0.5EVS1GEM2.4507
0.55GVVS2GEM2.4703
0.51FVVS2GEM2.4969
0.55HIFGEM2.5235
0.55FVS1GEM2.5235
0.52FVVS2GEM2.5445
0.52EVS1GEM2.5445
0.57GVVS2GEM2.5557
0.56FVS1GEM2.5669
0.53FVVS2GEM2.5907
0.54EVS1GEM2.6369
0.59GVVS2GEM2.6411
0.51FVVS1GEM2.6957
0.7IVS2GEM2.7027
0.56EVS1GEM2.73
0.53DVS1GEM2.7447
0.54FVVS1GEM2.8462
0.55EVVS2GEM2.8966
0.73IVS1GEM2.9547
0.6HIFGEM3.0037
0.6FVS1GEM3.0037
0.66HVVS1GEM3.01
0.75IVS1GEM3.0485
0.63GVVS2GEM3.0807
0.74HVS2GEM3.2095
0.75IVVS2GEM3.2669
0.73IVVS1GEM3.3089
0.64GVVS1GEM3.3313
0.8IVS2GEM3.3824
0.82IVS2GEM3.4636
0.73HVS1GEM3.521
0.73HVS1GEM3.521
0.7HVVS2GEM3.5854
0.7HVVS2GEM3.5854
0.7GVS1GEM3.5854
0.7GVS1GEM3.5854
0.7FVS2GEM3.5854
0.7FVS2GEM3.5854
0.71HVVS2GEM3.6351
0.71HVVS2GEM3.6351
0.71FVS2GEM3.6351
0.72FVS2GEM3.6841
0.78HVS1GEM3.7702
0.8IVVS2GEM3.8087
0.7FVS1GEM3.857
0.71FVS1GEM3.9102
0.72HVVS1GEM3.9634
0.84HVS2GEM3.9935
0.73EVS2GEM4.0166
0.7EVS1GEM4.06
0.74GVVS2GEM4.0705
0.62EVVS1GEM4.0915
0.71FVVS2GEM4.1167
0.71EVS1GEM4.1167
0.72EVS1GEM4.1727
0.7FVVS1GEM4.3995
0.71DVS1GEM4.4604
0.63EIFGEM4.5584
0.9IVVS2GEM4.6774
0.89HVS1GEM4.6963
0.85FVS2GEM4.7635
0.86HVVS2GEM4.8174
0.77FVVS1GEM4.8433
0.83EVS2GEM5.0092
0.75DVVS2GEM5.1576
0.9FVS1GEM5.376
1IVS2GEM5.4726
1.01IVS2GEM5.5265
1IVS1GEM5.6665
1.01IVVS2GEM5.9185
1.05IVVS2GEM6.1467
1HVS2GEM6.1516
1.01IVVS1GEM6.2111
1.01HVS2GEM6.2111
1.07IVVS2GEM6.2615
1.01HVS1GEM6.4071
1GVS2GEM6.4183
1GVS2GEM6.4421
1.06HVS2GEM6.5114
1FVS2GEM6.636
1.04IIFGEM6.6941
1.01FVS2GEM6.7011
1GVS1GEM6.7333
1.1HVS2GEM6.7522
1.02FVS2GEM6.7662
1.06GVS2GEM6.8201
1EVS2GEM6.8299
1.01EVS2GEM6.8971
0.76DIFGEM6.9195
1GVVS2GEM6.9272
1.02GVVS2GEM7.063
1.01FVS1GEM7.1904
1.02FVS1GEM7.2604
1.04FVS1GEM7.3997
1FVVS2GEM7.4116
1EVS1GEM7.4116
1.01EVS1GEM7.4844
1FVS1GEM7.4991
1.03EVS1GEM7.63
1DVS1GEM7.9933
1FIFGEM9.7391
1DVVS1GEM10.9074
1.01DVVS1GEM11.2056
0.2GVS2INT0.4466
0.18GVVS2INT0.4935
0.2GVS1INT0.4935
0.18HIFINT0.5075
0.19HIFINT0.5306
0.18FVVS2INT0.5355
0.19GVVS1INT0.56
0.19FVVS2INT0.56
0.18GIFINT0.5621
0.18GIFINT0.5621
0.18FVVS1INT0.5761
0.19GIFINT0.5894
0.19FVVS1INT0.6041
0.2GIFINT0.616
0.2DVS1INT0.616
0.21GIFINT0.6433
0.21DVS1INT0.6433
0.19FIFINT0.6769
0.19DVVS2INT0.6769
0.23GIFINT0.6965
0.19EIFINT0.735
0.21FIFINT0.7399
0.25IIFINT0.7574
0.24HIFINT0.7756
0.26IIFINT0.7847
0.23FIFINT0.8029
0.21EIFINT0.8043
0.25HIFINT0.8043
0.22EIFINT0.8386
0.28IIFINT0.8393
0.3HVVS2INT0.8526
0.27HIFINT0.8631
0.29IIFINT0.8666
0.23EIFINT0.8736
0.26FVVS2INT0.882
0.25GIFINT0.8981
0.3IIFINT0.9093
0.31IIFINT0.9359
0.26FVVS1INT0.9555
0.3GVVS1INT1.0213
0.3FVVS2INT1.0213
0.32HIFINT1.0234
0.29GIFINT1.0297
0.25FIFINT1.0395
0.33HIFINT1.0521
0.41IVVS2INT1.0542
0.26FIFINT1.0773
0.35GVVS2INT1.078
0.3EVVS2INT1.106
0.27FIFINT1.1165
0.41IVVS1INT1.1312
0.31FVVS1INT1.1396
0.31EVVS2INT1.1396
0.34FVVS2INT1.1452
0.34FVVS1INT1.2411
0.35FVVS1INT1.2747
0.4GIFINT1.5932
0.48FVS1INT1.6681
0.47FVVS2INT1.8557
0.52IIFINT2.1665
0.56GVVS2INT2.429
0.5GIFINT2.5564
0.55FVVS2INT2.5942
0.51FVVS1INT2.6054
0.51EVVS2INT2.6054
0.58GVVS1INT2.6747
0.56EVVS2INT2.849
0.58FVVS1INT2.9463
0.58EVVS1INT3.3817
0.7GVVS2INT3.7282
0.7GVVS1INT3.9249
0.78GVVS2INT4.1559
0.76FVVS2INT4.2665
0.71DVS1INT4.312
1.01IVS1INT5.7225
1.01HVS2INT6.2111
1HVVS2INT6.5394
1.01GVS1INT6.7991
CaratColourClarityLabPrice (US$1000)

<colgroup><col span="4"><col></colgroup><tbody>
</tbody>

1) Construct a pivot table with Clarity as the row variable and Colour as the column variable. This was my response below (I hope that this is correct):

Count of ColourColumn Labels
Row LabelsDEFGHIGrand Total
IF1581111844
VS1718251211881
VS22714914753
VVS125181210552
VVS2491721151278
Grand Total164482656140308

<colgroup><col><col span="6"><col></colgroup><tbody>
</tbody>

2) Use your pivot table to construct a contingency table showing percentages in each clarity category by colour. (This means that each column of your table should add up to 100%.) Pay attention to rounding in your display..
 

Some videos you may like

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

sheetspread

Well-known Member
Joined
Sep 19, 2005
Messages
5,119
In the PivotTable Tools Options ribbon under Show Values as, click % of column total
 

Watch MrExcel Video

Forum statistics

Threads
1,123,087
Messages
5,599,654
Members
414,325
Latest member
kfg1287

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top