Pls both parts for UPVOTE
Using Excel create four histograms, properly labeled, depicting the data from the frequency distributions in #a and #b below.
a) Using the variable Age, construct TWO frequency distributions to summarize the Ages of students born in the USA and those born outside the USA. Use 5 classes to construct your frequency distribution. For each frequency distribution, show your calculations for the class width and then list the:
Lower limits and upper limits
Class boundaries
Class mid-points
Relative frequencies
Cumulative frequencies
b) Using the variable hours spent on school work at home, construct TWO frequency distributions to summarize the hours of students born in the USA and those born outside the USA. Use 5 classes to construct your frequency distribution. For each frequency distribution, show your calculations for the class width and then list the:
Lower limits and upper limits
Class boundaries
Class mid-points
Relative frequencies
Cumulative frequencies
Students in US:
Stu ID | Age | GPA | Hrs spend on sch wrk |
175 | 20 | 3.20 | 10 |
178 | 20 | 2.40 | 12 |
181 | 17 | 3.98 | 6 |
184 | 20 | 3.00 | 15 |
187 | 27 | 2.20 | 6 |
190 | 19 | 3.00 | 7 |
193 | 3.10 | 15 | |
196 | 20 | 6 | |
199 | 43 | 3.67 | 12 |
202 | 44 | 3.80 | 10 |
205 | 26 | 3.80 | 4 |
208 | 25 | 2.50 | 5 |
211 | 21 | 3.72 | 10 |
214 | 29 | 2.54 | 4 |
217 | 33 | 3.85 | 21 |
220 | 18 | 3.00 | 5 |
223 | 21 | 3.00 | 6 |
226 | 19 | 3.00 | 5 |
229 | 26 | 3.00 | 4 |
232 | 19 | 2.81 | 4 |
235 | 19 | 3.00 | 6 |
238 | 28 | 3.50 | 10 |
241 | 19 | 4.00 | 12 |
244 | 20 | 3.20 | 2 |
247 | 21 | 9 | |
250 | 20 | 2.51 | 3 |
253 | 20 | 3.20 | 5 |
256 | 23 | 2 | |
259 | 20 | 3.10 | 27 |
262 | 26 | 2.50 | 8 |
Students outside US :
Stu ID | Age | GPA | Hrs spend on sch wrk |
3 | 48 | 4.00 | 7 |
6 | 47 | 2.79 | 14 |
9 | 45 | 3.48 | 5 |
12 | 19 | 4.00 | 30 |
15 | 24 | 3.10 | 10 |
18 | 34 | 3.24 | 2 |
21 | 44 | 36.00 | 6 |
24 | 19 | 2.85 | 7 |
27 | 19 | 2.80 | 10 |
30 | 27 | 3.40 | 8 |
33 | 28 | 2.90 | 16 |
36 | 27 | 3.40 | 8 |
39 | 28 | 2.90 | 16 |
42 | 21 | 2.9 | 4 |
45 | 20 | 2.50 | 6 |
48 | 23 | 3.3 | 18 |
51 | 41 | 3.80 | 7 |
54 | 21 | 2.60 | 26 |
57 | 39 | 5 | |
60 | 18 | 3.10 | 12 |
63 | 28 | 3.70 | 20 |
66 | 35 | 8 | |
69 | 37 | 2.80 | 6 |
72 | 21 | N/A | 21 |
75 | 20 | 3.00 | 4 |
78 | 30 | 3.50 | 6 |
81 | 21 | 3.1 | 4 |
84 | 21 | 3.20 | 3 |
87 | 37 | 2.86 | 3 |
90 | 19 | 3.30 | 12 |
Pls both parts for UPVOTE Using Excel create four histograms, properly labeled, depicting the data from...
Born outside the United States Stu ID Age Total Crd Hrs GPA Hrs spend on sch wrk 205 26 48 2.90 25 209 57 23 2.98 7 198 32 78 3.40 8 230 44 34 3.70 10 135 19 0 3.00 4 178 34 51 3.50 8 224 23 26 3.00 20 328 45 23 3.25 12 169 19 23 3.00 4 164 26 51 3.8 2 266 49 20 3.91 10 202 20 12 3.60 4 219 57 35...
Using the answers from the table above, answer ALL of the questions below. For questions 1 - 13, draw a normal curve and indicate the area that you are calculating the probability of. For questions 14 – 22, use the appropriate formulas and show all of your calculations. Be sure to turn in the table above along with your answers to all of the questions below. Place your answers in a folder with your name clearly written at the top...
can you upload the answer in excel 7. Following are ages of 30 students in an ARC Boot Camp class: 18 30 20 21 28 26 20 21 19 22 26 38 18 19 23 25 19 20 18 21 29 35 17 22 19 24 23 21 20 25 Construct an expanded stem-and-leaf display for the given data. Stem Leaves 2. The following data values are the actual low temperatures recorded near the author's home. Construct a frequency distribution...
frequency table histogram frequency polygon ogive 100% (?) New Open Save Print Import Copy Paste Format Undo Redo AutoSum Sort A-Z Sort Z-A Gallery Toolbox Zoom Help Charts SmartArt Gr Word Protein Grams In Fast Food 223 3 25 12 38 22 21 427 27 1429 27 42 34 35 23 12 27 29 15 31 6 30 7 15 57 35 9 35 10 20 11 18 12 24 20 26 19 35 Tasks 1. Complete the fequency table...
Data were collected during the time period in which a constant number of checkout counters were open. The total number of customers in the store and the waiting times in minutes were recorded. a) Use Excel to construct the scatter plot. b) Determine the linear regression equation between a number of customers and waiting time include that on the graph c) Predict the waiting period when there are 20 customers in the store. d) Show r= coefficient of regression and...
File Ed Yew ranoform e Srepha Anaivza Custom Hours Work GPA Absences yar ed less than 1... 3.00 4.00 less than 1.. 2 4.00 2.00 less than 1... 2.50 3.00 less than 1.. 3.80 1.00 less than 1.. 2.70 2.00 less than 1. 3.20 5.00 7 less than 1. 4.00 6.00 less than 1.. 8 3.80 7.00 less than 1... 2.90 9.00 10 less than 1... 3.10 4.00 11 less than 1. 3.10 7.00 12 less than 1... 2.00 8.00...
[28] QUESTION 6 The following data show the Thirty vehicles filled up with petrol at a certain filling station in Pretoria amount of petrol (in litres) supplied to each vehicle 20 12 15 32 30 15 31 25 13 35 27 18 24 28 36 17 25 23 18 37 25 22 27 21 23 24 16 13 31 11 6.1 Set up a grouped frequency table for this data, using class widths of 5 litres, with 10 litres as...
histogram ogive frequency polygon frequency table 00% Redo AutoSum Sort A-Z Sort Z-A Gallery Toolbox Zoom Help ste Format n Save Print Import Co 21318 35 24 3 19 25 4923 14 19 17 4 21 5 11 6 20 713 22 25 18 8 11 9 16 17 18 15 28 25 10 1827 20 16 112 Tasks 1. Complete the fequency table with 6 classes 13 14 15 Class Limit Class Boundarles mldpoint frequency cumulative relative frequency frequency...
for Question 10 make frequency distribution only. Thank you 9. The numbers below are the number of aggres sive acts for each preschool child over a week in a class of 25 students. First, construct a fre- quency distribution in the manner of Table 2-9, including the real limits, size, and midpoints of the class intervals. For such a small distribu- tion only five or so intervals are necessary. Sec- ond, compose a relative frequency, cumulative frequency, and cumulative relative...
Use the data in the table below to calculate Cp, Cpl, Cpu, and Cpk, assuming that the specifications are 3.75 ± 1.26. Do not round intermediate calculations. Round your answers to three decimal places. Sample 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Observations 3.65 3.70 3.69 4.23 3.96 3.41 3.28 4.17 4.25 3.60 4.16 3.28 3.88 3.56 3.54 3.73 3.46 3.30 3.40 3.29 4.27 3.65 3.48 3.71 3.61 3.36 3.12 3.43 3.70...