I’m trying to learn for my Business class and I’m stuck. Can you help?
For these project assignments throughout the course, you will need to reference the data in the ROI Excel spreadheet. Download it here.
- For each of the 2 majors create a frequency distribution table and histogram using the column ‘Annual % ROI’. Group the classes starting at 6% (0.06), ending at 11% (0.11), and have the class width be a half percent 0.5% (0.005). Make sure that there are NO overlapping bars. For example, if one bar is 0.060-0.064, then the next bar can’t start with 0.064. It would have to start with0.065. This histogram is used again and again… Make sure it is correct. You will have to adjust the table Excel generates.
- In a highlighted box, interpret your results. Do the samples represent public and private schools equally? Why is that NOT necessarily a problem? Is there a certain histogram bar that is higher than all the others? What does this mean in terms of ROI? These are not the only questions you can use to interpret the results, but they are a push in the right direction. Keep going. What else do you see?