1. Complete the following in regard to the hair color category of the data set: a. In the region to the right, make an appropriately labeled frequency table in regard ONLY to the hair color data (for this portion, ignore all other variables in the data set except hair color). Next, extend the frequency table to include a relative frequency column. Use a fill handle to create the relative frequency column. Finally, create a bar chart graphic (NOT a histogram) from the frequency table, complete with title and labeled axes. Brown Red Brown Brown Brown Brown Blonde Brown Brown Brown Black Blonde Brown Brown Brown Brown Brown Brown Red Brown Brown Red Blonde Brown Brown Brown Brown Blonde Brown Brown Purple Black Blonde Blonde Blonde Black Brown Blonde Black Red Brown Brown Brown Brown Brown Black Red Blonde Brown Brown Blonde Brown Brown Black Blonde Brown Brown Brown Blonde Brown Brown Black Black Red Blonde Brown Blonde Brown Blonde Blonde Brown Brown Brown Brown Brown Blonde Brown Blonde Red Blonde Brown Brown Blonde Brown Black Brown Blonde Black Red Brown Brown Brown
1. Complete the following in regard to the hair color category of the data set:
a.
In the region to the right, make an appropriately labeled frequency table in regard ONLY to the hair color data (for this portion, ignore all other variables in the data set except hair color).
Next, extend the frequency table to include a relative frequency column. Use a fill handle to create the relative frequency column.
Finally, create a bar chart graphic (NOT a histogram) from the frequency table, complete with title and labeled axes.
| Brown |
| Red |
| Brown |
| Brown |
| Brown |
| Brown |
| Blonde |
| Brown |
| Brown |
| Brown |
| Black |
| Blonde |
| Brown |
| Brown |
| Brown |
| Brown |
| Brown |
| Brown |
| Red |
| Brown |
| Brown |
| Red |
| Blonde |
| Brown |
| Brown |
| Brown |
| Brown |
| Blonde |
| Brown |
| Brown |
| Purple |
| Black |
| Blonde |
| Blonde |
| Blonde |
| Black |
| Brown |
| Blonde |
| Black |
| Red |
| Brown |
| Brown |
| Brown |
| Brown |
| Brown |
| Black |
| Red |
| Blonde |
| Brown |
| Brown |
| Blonde |
| Brown |
| Brown |
| Black |
| Blonde |
| Brown |
| Brown |
| Brown |
| Blonde |
| Brown |
| Brown |
| Black |
| Black |
| Red |
| Blonde |
| Brown |
| Blonde |
| Brown |
| Blonde |
| Blonde |
| Brown |
| Brown |
| Brown |
| Brown |
| Brown |
| Blonde |
| Brown |
| Blonde |
| Red |
| Blonde |
| Brown |
| Brown |
| Blonde |
| Brown |
| Black |
| Brown |
| Blonde |
| Black |
| Red |
| Brown |
| Brown |
| Brown |
b. Directly below, create a statement about “hair color” that the statistical analysis from part a. supports or suggests. Remember this statement is only to be made based on the sampled students' data for the online course as shown in your work in part a.
c. Next, create ANY new statement/claim about “hair color” in regard to ALL students at FHSU (this claim does not have to match the information in the bar chart). Then, briefly discuss whether the chart proves or disproves your statement. Finally, what process would be required to measure statistically whether or not the claim you made here is supported/discounted by the sample evidence?
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 2 images
