Solved Statistics Questions
Solved Statistics Questions
There is one attachment to this message: § Sample Exercises – Chapter 1 (for your review) Your first week assignments are as follows: 1. Download and read the syllabus. Let me know your questions.2. Add-in Excel’s Data Analysis ToolPak. If your Excel does not have it already (see the Syllabus). 3. Review/learn Excel’s Data Analysis ToolPak. 4. Read/learn Chapter 1. 5. Review sample exercises of Chapter 1.6. Complete homework exercises: number 1-7 on page 5, 1-25 on page 18, 1-34 on page 18, and 1-39 on page 19. Type your answers in MS Word following the same format I have used in Solution to Sample Exercises.
Hint: For exercise 1-39, you go to:
Data Analysis
Random Number Generation
Number of Variables: 5
Number of Random Numbers: 8
Parameters:
- 578
Output Range: $A$1
Here, I am choosing 5 columns and 8 rows to get 40 random numbers. You may choose other number as long as they multiply to 40.
Attachment: Sample Exercises:
Chapter 1: Solution to Sample Exercises
Page 5 – Number 1-3
A bar chart is used whenever you want to display data that has already been categorized while a histogram is used to display data over a range of values for the factor under consideration. Another fundamental difference is that there typically are gaps between the bars on a bar chart but there are no gaps between the bars of a histogram.
Page 5 – Number 1-7 (This is also a homework exercise; do solve it yourself)
The appropriate chart in this case is a histogram where the horizontal axis contains the number of missed days and the area of the bars represent the number of employees who missed each number of days.
Note: Leave no gap between the bars.
Page 18 – Number 1-26
To determine the range of employee numbers for the first part selected in a systematic random sample use the following:
Part range =
Thus, the first employee selected will come from parts 1-180. Once that employee number is randomly selected, the second employee will be the one numbered 100 higher than the first, and so on.
Page 19 – Number 1-40
- The population should be all users of cross-country ski lots in Colorado.
- Several sampling techniques could be selected. Be sure that some method of ensuring randomness is discussed. In addition, some students might give greater weight to frequent users of the lots. In which case the population would really be user days rather than individual users.
- Students using Excel should use the Data, Data Analysis, Random Number Generation. Students’ answers will differ since Excel generates different streams of random numbers each time it is used. Since the application requires integer numbers, the Decrease Decimal option should be used.
Page 23 – Number 1-49
- Cross-sectional
- Time-series
- Cross-sectional
- Cross-sectional
- Time-Series