Exam 3: Visualizing and Exploring Data

To select a chart type in Excel from the Charts group, which tab has to be accessed?

Use the data given below to answer the following question(s). Following is an extract from the Cost per Order Database of Grogtes LLC. Item Category Item Item Cost Units Cost per Order Nuts N101 \ 2.44 94 \ 229.36 Screws S101 \ 20.44 49 \ 1,001.56 Nuts N102 \ 5.44 35 \ 190.40 Screwdriver SD 101 \ 20.44 26 \ 531.44 Nuts N102 \ 3.44 55 \ 189.20 Screws S102 \ 5.44 59 \ 320.96 Nuts N101 \ 2.44 74 \ 180.56 Nuts N102 \ 5.44 89 \ 484.16 Nuts N101 \ 2.44 31 \ 75.64 Screws S103 \ 9.44 59 \ 556.96 Nuts N102 \ 5.44 89 \ 484.16 Screws S101 \ 2.44 28 \ 68.32 Screws S101 \ 20.44 80 \ 1,635.20 Nuts N102 \ 5.44 34 \ 184.96 Nails NG101 \ 125.45 1 \ 125.45 Bolts B101 \ 16.44 15 \ 246.60 Screws S103 \ 9.44 27 \ 254.88 Screwdriver SD 102 \ 9.44 63 \ 594.72 Screwdriver SD 101 \ 20.44 14 \ 286.16 Bolts B102 \ 5.44 95 \ 516.80 Nuts N103 \ 1.74 66 \ 114.84 Bolts B101 \ 16.44 73 \ 1,200.12 Screws S103 \ 9.44 45 \ 424.80 Screws S104 \ 15.45 86 \ 1,328.70 Screws S102 \ 5.44 3 \ 16.32 Screws S101 \ 20.44 6 \ 122.64 Bolts B 102 \ 5.44 49 \ 266.56 Nuts N101 \ 2.44 65 \ 158.60 Screw driver SD 103 \ 5.44 95 \ 516.80 Nuts N103 \ 1.74 52 \ 90.48 Screws S103 \ 9.44 79 \ 745.76 Nailgun pack NG101 \ 125.45 4 \ 501.80 Bolts B102 \ 5.44 61 \ 331.84 Bolts B103 \ 12.94 54 \ 698.76 Bolts B104 \ 24.40 41 \ 1,000.40 Nails NG102 \ 275.45 2 \ 550.90 Nuts N103 \ 1.74 6 \ 10.44 Screw driver SD 104 \ 2.44 75 \ 183.00 Screws S101 \ 20.44 56 \ 1,144.64 Nuts N103 \ 1.74 13 \ 22.62 Screws \ 102 \ 5.44 10 \ 54.40 $\quad$ Screws S101 \ 20.44 93 \ 1,900.92 Screws S102 \ 5.44 27 \ 146.88 -Which of the following observations is closest to the 87th percentile of costs per order?

Use the data given below to answer the following question(s). Following is an extract from the Cost per Order Database of Grogtes LLC. Item Category Item Item Cost Units Cost per Order Nuts N101 \ 2.44 94 \ 229.36 Screws S101 \ 20.44 49 \ 1,001.56 Nuts N102 \ 5.44 35 \ 190.40 Screwdriver SD 101 \ 20.44 26 \ 531.44 Nuts N102 \ 3.44 55 \ 189.20 Screws S102 \ 5.44 59 \ 320.96 Nuts N101 \ 2.44 74 \ 180.56 Nuts N102 \ 5.44 89 \ 484.16 Nuts N101 \ 2.44 31 \ 75.64 Screws S103 \ 9.44 59 \ 556.96 Nuts N102 \ 5.44 89 \ 484.16 Screws S101 \ 2.44 28 \ 68.32 Screws S101 \ 20.44 80 \ 1,635.20 Nuts N102 \ 5.44 34 \ 184.96 Nails NG101 \ 125.45 1 \ 125.45 Bolts B101 \ 16.44 15 \ 246.60 Screws S103 \ 9.44 27 \ 254.88 Screwdriver SD 102 \ 9.44 63 \ 594.72 Screwdriver SD 101 \ 20.44 14 \ 286.16 Bolts B102 \ 5.44 95 \ 516.80 Nuts N103 \ 1.74 66 \ 114.84 Bolts B101 \ 16.44 73 \ 1,200.12 Screws S103 \ 9.44 45 \ 424.80 Screws S104 \ 15.45 86 \ 1,328.70 Screws S102 \ 5.44 3 \ 16.32 Screws S101 \ 20.44 6 \ 122.64 Bolts B 102 \ 5.44 49 \ 266.56 Nuts N101 \ 2.44 65 \ 158.60 Screw driver SD 103 \ 5.44 95 \ 516.80 Nuts N103 \ 1.74 52 \ 90.48 Screws S103 \ 9.44 79 \ 745.76 Nailgun pack NG101 \ 125.45 4 \ 501.80 Bolts B102 \ 5.44 61 \ 331.84 Bolts B103 \ 12.94 54 \ 698.76 Bolts B104 \ 24.40 41 \ 1,000.40 Nails NG102 \ 275.45 2 \ 550.90 Nuts N103 \ 1.74 6 \ 10.44 Screw driver SD 104 \ 2.44 75 \ 183.00 Screws S101 \ 20.44 56 \ 1,144.64 Nuts N103 \ 1.74 13 \ 22.62 Screws \ 102 \ 5.44 10 \ 54.40 $\quad$ Screws S101 \ 20.44 93 \ 1,900.92 Screws S102 \ 5.44 27 \ 146.88 -Which of the following can be used to quickly create cross-tabulations?

Which of the following charts allows plotting of multiple dimensions of several data series?

Explain with an example the filtering tool provided by Excel for simple criteria.

Use the data given below to answer the following question(s). Following is an extract from the Employee Payroll Database of HFR Informatics Inc. Employee Ethnic Group Gender Rank / Grade Pay Scale Maria Asian American Female 3 A Peter White American Male 2 B George Hispanic Male 1 C American Smith Black American Female 1 D Johnson Alaska Native Male 2 E Thompson Asian American Male 2 B Martinez Alaska Native Male 3 A Lewis White American Female 2 B Lee Black American Male 2 A Taylor Asian American Female 1 B Carter Asian American Male 2 C Edwards Hispanic Male 2 E American Bailey White American Male 2 B Cooper White American Male 2 A Bill Alaska Native Male 3 E Cox Asian American Male 1 A Perry Hispanic Female 2 C American Flores Alaska Native Female 2 B Woods White American Male 3 E Cole Asian American Female 1 A -What is the cumulative relative frequency of employees on a 'A to D' pay scale?

Use the data given below to answer the following question(s). Following is the Sales database of Pointler's Inc., a manufacturer of clothing material. $\begin{array}{|l|l|l|l|l|l|}\hline \begin{array}{l}\text { Item } \\\text { Type }\end{array} & \text { Item } \mathrm{ID} & \text { Region } & \text { Buyer } & \begin{array}{l}\text { Unit } \\\text { Cost } \\(\$)\end{array} & \text { Units } \\\hline \text { Denim } & \text { D101 } & \text { Quintasia } & \text { Peter } & 9.79 & 101 \\\hline \text { Cotton } & \text { C101 } & \text { Prioland } & \text { Kane } & 27.79 & 56 \\\hline \text { Denim } & \text { D102 } & \text { Prioland } & \text { Jones } & 12.79 & 42 \\\hline \text { Leather } & \text { L101 } & \text { Prioland } & \text { Gerry } & 27.79 & 33 \\\hline \text { Denim } & \text { D103 } & \text { Dygertia } & \text { Sarah } & 10.79 & 62 \\\hline \text { Cotton } & \text { C102 } & \text { Quintasia } & \text { Peter } & 12.79 & 66 \\\hline \text { Denim } & \text { D101 } & \text { Prioland } & \text { Audrey } & 9.79 & 81 \\\hline \text { Denim } & \text { D102 } & \text { Prioland } & \text { Jones } & 12.79 & 96 \\\hline \text { Denim } & \text { D101 } & \text { Dygertia } & \text { Thomas } & 9.79 & 38 \\\hline \text { Cotton } & \text { C103 } & \text { Quintasia } & \text { Peter } & 16.79 & 66 \\\hline \text { Denim } & \text { D102 } & \text { Prioland } & \text { Mary } & 12.79 & 96 \\\hline \text { Cotton } & \text { C105 } & \text { Quintasia } & \text { Henry } & 9.79 & 35 \\\hline \text { Cotton } & \text { C101 } & \text { Quintasia } & \text { Philip } & 27.79 & 87 \\\hline \text { Denim } & \text { D102 } & \text { Quintasia } & \text { Peter } & 12.79 & 41 \\\hline \text { Jute } & \text { J101 } & \text { Prioland } & \text { Simson } & 132.8 & \text { 8 } \\\hline \text { Fur } & \text { F101 } & \text { Quintasia } & \text { Peter } & 23.79 & 22 \\\hline \text { Cotton } & \text { C103 } & \text { Prioland } & \text { Mary } & 16.79 & 34 \\\hline \text { Leather } & \text { L102 } & \text { Quintasia } & \text { Peter } & 16.79 & 70 \\\hline \text { Leather } & \text { L101 } & \text { Quintasia } & \text { Philip } & 27.79 & 21 \\\hline \text { Fur } & \text { F102 } & \text { Prioland } & \text { Kane } & 12.79 & 102 \\\hline \text { Denim } & \text { D104 } & \text { Prioland } & \text { Simson } & 9.09 & 73 \\\hline \text { Fur } & \text { F101 } & \text { Quintasia } & \text { Philip } & 23.79 & 80 \\\hline \text { Cotton } & \text { C103 } & \text { Prioland } & \text { Gerry } & 16.79 & 52 \\\hline \text { Cotton } & \text { C104 } & \text { Prioland } & \text { Simson } & 22.8 & 93 \\\hline \text { Cotton } & \text { C101 } & \text { Quintasia } & \text { Peter } & 12.79 & 10 \\\hline\end{array}$ -To construct a frequency distribution for categorical data, the

Use the data given below to answer the following question(s). Following is an extract from the Employee Payroll Database of HFR Informatics Inc. Employee Ethnic Group Gender Rank / Grade Pay Scale Maria Asian American Female 3 A Peter White American Male 2 B George Hispanic Male 1 C American Smith Black American Female 1 D Johnson Alaska Native Male 2 E Thompson Asian American Male 2 B Martinez Alaska Native Male 3 A Lewis White American Female 2 B Lee Black American Male 2 A Taylor Asian American Female 1 B Carter Asian American Male 2 C Edwards Hispanic Male 2 E American Bailey White American Male 2 B Cooper White American Male 2 A Bill Alaska Native Male 3 E Cox Asian American Male 1 A Perry Hispanic Female 2 C American Flores Alaska Native Female 2 B Woods White American Male 3 E Cole Asian American Female 1 A -What is the relative frequency of Female employees?

Use the data given below to answer the following question(s). Following is the Sales database of Pointler's Inc., a manufacturer of clothing material. $\begin{array}{|l|l|l|l|l|l|}\hline \begin{array}{l}\text { Item } \\\text { Type }\end{array} & \text { Item } \mathrm{ID} & \text { Region } & \text { Buyer } & \begin{array}{l}\text { Unit } \\\text { Cost } \\(\$)\end{array} & \text { Units } \\\hline \text { Denim } & \text { D101 } & \text { Quintasia } & \text { Peter } & 9.79 & 101 \\\hline \text { Cotton } & \text { C101 } & \text { Prioland } & \text { Kane } & 27.79 & 56 \\\hline \text { Denim } & \text { D102 } & \text { Prioland } & \text { Jones } & 12.79 & 42 \\\hline \text { Leather } & \text { L101 } & \text { Prioland } & \text { Gerry } & 27.79 & 33 \\\hline \text { Denim } & \text { D103 } & \text { Dygertia } & \text { Sarah } & 10.79 & 62 \\\hline \text { Cotton } & \text { C102 } & \text { Quintasia } & \text { Peter } & 12.79 & 66 \\\hline \text { Denim } & \text { D101 } & \text { Prioland } & \text { Audrey } & 9.79 & 81 \\\hline \text { Denim } & \text { D102 } & \text { Prioland } & \text { Jones } & 12.79 & 96 \\\hline \text { Denim } & \text { D101 } & \text { Dygertia } & \text { Thomas } & 9.79 & 38 \\\hline \text { Cotton } & \text { C103 } & \text { Quintasia } & \text { Peter } & 16.79 & 66 \\\hline \text { Denim } & \text { D102 } & \text { Prioland } & \text { Mary } & 12.79 & 96 \\\hline \text { Cotton } & \text { C105 } & \text { Quintasia } & \text { Henry } & 9.79 & 35 \\\hline \text { Cotton } & \text { C101 } & \text { Quintasia } & \text { Philip } & 27.79 & 87 \\\hline \text { Denim } & \text { D102 } & \text { Quintasia } & \text { Peter } & 12.79 & 41 \\\hline \text { Jute } & \text { J101 } & \text { Prioland } & \text { Simson } & 132.8 & \text { 8 } \\\hline \text { Fur } & \text { F101 } & \text { Quintasia } & \text { Peter } & 23.79 & 22 \\\hline \text { Cotton } & \text { C103 } & \text { Prioland } & \text { Mary } & 16.79 & 34 \\\hline \text { Leather } & \text { L102 } & \text { Quintasia } & \text { Peter } & 16.79 & 70 \\\hline \text { Leather } & \text { L101 } & \text { Quintasia } & \text { Philip } & 27.79 & 21 \\\hline \text { Fur } & \text { F102 } & \text { Prioland } & \text { Kane } & 12.79 & 102 \\\hline \text { Denim } & \text { D104 } & \text { Prioland } & \text { Simson } & 9.09 & 73 \\\hline \text { Fur } & \text { F101 } & \text { Quintasia } & \text { Philip } & 23.79 & 80 \\\hline \text { Cotton } & \text { C103 } & \text { Prioland } & \text { Gerry } & 16.79 & 52 \\\hline \text { Cotton } & \text { C104 } & \text { Prioland } & \text { Simson } & 22.8 & 93 \\\hline \text { Cotton } & \text { C101 } & \text { Quintasia } & \text { Peter } & 12.79 & 10 \\\hline\end{array}$ -If a data set has 'c' number of observations, the relative frequency of category 'l' is computed as .

Peige, a stock broker, has data consisting of price, price/earnings ratio, and market capitalization for seven different stocks on one particular day. She wishes to plot these three variables in two dimensions. Which of the following charts must Peige use?