RHI Management resources conducted a survey of 1400 chief financial officers. When asked how much an impact interest rates have on the purchasing decisions they make for their company, 672 reported that they have little or no impact, 700 financial officers stated that interest rates have a significant impact or somewhat significant impact, and 28 reported that they were unsure.
a. Construct a frequency and percentage summary table for the survey.
b. Form a bar chart for the responses to the survey.
c. Form a pie chart for the responses to the survey.
The following set of data is from a sample of size n=7:
12 7 4 9 0 7 3
a. compute the mean, median, and range.
b. Compute range, interquartile range, variance, standard deviation, and coefficient of variation.
c. Describe the shape of the data set.
Solution uses Excel to produce summary tables, a bar chart, a pie chart, mean, median, range, variance, standard deviation, coefficient of variation and interquartile range of a data set. The shape of the data is also describes. 2 questions within. Cells can be highlighted to show the formulas.