Business Maths Statistics Assignment 1
ASSIGNMENT 1
DESCRIPTIVE STATISTICS USING EXCEL
PART B.
QA).
The pie charts show that a higher percentage of the male gender has tried the product in comparison to the female gender. Over 50% of both genders have tried the product. However, the fact that the percentage of males who tried the product is higher, suggests that gender does play a role in whether the people will try the product. Yet the role genders play is small, because the difference between the percentage of females who tried the product and males who tried the product is small at only 7%.
However, since the graphs do not compare the genders within the total sample surveyed and are only a percentage of each specific gender, more …show more content…
This is because the standard deviation for the female gender is larger than the standard deviation for the male gender, and the mean is smaller than the mean for the male gender.
QD).
The graph shows that the largest amount of people who tried the product, have an income midpoint of $37,500. It also shows that the least amount of people who tried the product earn over the midpoint income of $87,500. The graph is positively skewed which shows, that as the midpoint income increases past $62,500 the amount of people who will try the product significantly decreases. This means that almost 50% of the people surveyed earn less than the $62,500 income midpoint.
The graph does tell us that over 23% of the people surveyed who have tried the product fall into the $37,500 income midpoint but it doesn’t tell us exactly where. It shows us that this group had the highest number of people try the product. It also tells us that a total of over 35% of the people who have tried the product earn an income midpoint of $37,500 or less. Almost 50% of the people who have tried the product had an income from within one of these income midpoints.
QE).
The data for have tried is a nominal variable. The have tried variable is not numerical and does not need to be ranked, the data is either yes or no. It is an observation because we have simply counted the observations of yes or no and calculated percentages of the observations from the total sample of