57 A survey asked chief executives at leading U.S. firms the following question: "Where do you expect the U.S. economy to be 12 months from now?" A representative sample of their responses appears below. 12 points Better Worse Same Same Worse Better Same Worse Better Better Worse Same Same Same Worse Same Same Same Same Better Better Same Same Same Same 8 01:13:43 Click here for the Excel Data File 0-1. Construct frequency and relative frequency distributions that summarize the responses to the survey. (Hint: Use a Pivot Table) (Do not round intermediate calculations. Round "Relative Frequency" to 2 decimal places.) Frequency Relative Frequency Expectation Better Same Worse 6-2. Where did most chief executives expect the U.S. economy to be in 12 months? O Better Same O Worse 57 b. Select a pie chart and a bar chart for the frequency and relative frequency distributions found in part a-1. Chart A 12 points Pie-Chart Expectations of U.S. economy Bar-Chart Expectations of U.S economy 8 01:13:25 0.60 Worse Better 0.50 0.40 20% Better 24% Same Relative Frequency 0.30 0.20 Worse Same 56% 0.10 0.00 Better Worse Same Expectation Type Chart B Pic-Chart Expectations of U.S. economy Bar-Chart Expectations of US economy 0.50 0.40 Better 0.30 Worse 28% Better 32% Same Relative Frequency 0.20 Worse 0.10 12 points Chart B 8 01:13.26 Pie-Chart Expectations of U.S. economy Bar-Chart Expectations of U.S economy 0.50 0.40 Better Worse 28% 0.30 Better 32% Same Relative Frequency 0.20 Worse 0.10 Same 40% 0.00 Better Worse Same Expectation Type Chart Pie-Chart Expectations of U.S. economy Bar-Chart Expectations of US economy 0.50 0.40 Better Worse 28% 0.30 Better 40% Same Relative Frequency 0.20 Worse 0.10 Same 32% 0.00 Better Same Expectation Type worse O Chart A Chart B O Chart C