Need answers to questions #3 & 4 Project-1.Data-Set.xls Project 1 Instructions.d

Question

Need answers to questions #3 & 4 Project-1.Data-Set.xls Project 1 Instructions.docx 100% Charts SmartArt Review Paragr Styles BEma No SpacinHineadin Heading 11-He Normal No Spacing 11 MATH 2 PROJECT 1 INSTRUCTIONS Based on Larson & Farber: section 2.1 Use the Project I Data Set to create the graphs and tables in Questions 1-4 and to answer both parts cf Question 5. If you cannot figure out how to make the graphs and tables in Excel, you are welcome to draw them by hand and then submit them as a scanned document or photo 1. Open a blank Excel file and create a grouped frequency distribution of the maximum daily temperatures for the 50 states for a 30 day period. Use 8 classes. (8 points) Add midpoint, relative frequency, and cumulative frequency columns to your frequency distribution. (8 points) 2. 3. Create a frequency histogram using Excel. You will probably need to load the Data Analysis add-in within Excel. If you do not know how to create a histogram in Excel, view the video located at: http:/www.youtube.com/watch?vgQUeRwDik A simple bar graph will also work If you cannot get the histogram or bar graph features to work, you may, at the cost of a small two point penalty, draw a histogram by hand and then scan or take a photo (your phone can probably do this) of your drawing and email it to your instructor. (8 points) 4. Create a frequency polygon in Excel (or by hand with a 2 point penalty). For help, view http://www.youtube.com/watch?v 7Q.KdmDJirg (8 points) A. Do any of the temperatures appear to be unrealistic or in eror? It yes, which ones and why? (4 points) s. B. Explain how this affects your confidence in the validity of this data set (4 points) Project I is due by 11:59 p.m. (ET) on Monday of Module Weck 1

Explanation / Answer

Solution

Preparatory Work and Concept Back-up

The range of given observations: 43 to 111 is extended to make it convenient to work with, to 40 to 120.

Dividing the extended range into 8 classses of equal width, the classes with class limits will be:

40 - 49, 50 - 59, ......., 110 - 119

NOTE: Temperature is a continuous variable and hence the class limits need be converted to class boundaries by subtracting 0.5 from the lower limit and adding 0.5 to the upper limit.

Taking cognisance of the above important point, the classes with class boundaries will be:

39.5 - 49.5, 49.5 - 59.5, ........ 109.5 - 119.5

Mid-point of a class = (lower boundary + upper boundary)/2

Relative frequency = class frequency/total frequency

Cumulative frequency of a class = cumulative frequency of the previous class + current class frequency, except for the first class for which both are the same.

Frequency Distribution alonwith the other requisite parameters is presented in the table below: [Following codes are used to make the table comprehensive: CN Class No.; MP - Mid-point; TM- Tally Mark; FR- Frequency; RF - Relative Frequency; CF - Cumulative Frequency]

CN Class MP TM FR RF CF 1 39.5 - 49.5 44.5 | 1 0.02 1 2 49.5 - 59.5 54.5 | 1 0.02 2 3 59.5 - 69.5 64.5 - 0 0 2 4 69.5 - 79.5 74.5 - 0 0 2 5 79.5 - 89.5 84.5 ||||| 5 0.1 7 6 89.5 - 99.5 94.5 ||||| ||||| ||||| ||||| |||| 24 0.48 31 7 99.5 - 109.5 104.5 ||||| ||||| ||||| 15 0.30 46 8 109.5 - 119.5 114.5 |||| 4 0.08 50 TOTAL - 50 50 1.00 -

Related Questions

Navigate

• Browse (All)
• Browse N
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.