Question

Using appropriate formulas, find the mean and standard deviation of the frequency distribution you constructed. Use...

Using appropriate formulas, find the mean and standard deviation of the frequency distribution you constructed. Use the additional headings I have provided!!!!! Show how you use the appropriate formulas.   Again, treat the data as sample data.

Please show me how to use it in Excel. Data set is

43
42
41
39
38
37
37
30
27
27
26
26
24
18
14
52
43
41
39
37
37
27
27
22
21
21
20
19
19
17
Boundaries Midpoints (m) Freq. (f) Rel. Freq. mf (m - x̅)2 *f
12.5-19.5 16
19.5-26.5 23
26.5-33.5 30
33.5-40.5 37
40.5-47.5 44
47.5-54.5 51
x̅ =
s =

Homework Answers

Answer #1

Following is the completed table:

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Use the following data to test if there is a difference in mean age between mothers...
Use the following data to test if there is a difference in mean age between mothers of a boy and mothers of a girl at alpha =0.05. provide p-value     MomAge gestation sex weight preemie 35 39 F 3175 FALSE 22 42 F 3884 FALSE 35 39 F 3030 FALSE 23 40 F 3629 FALSE 23 42 F 3481 FALSE 25 38 F 2693 FALSE 25 40 F 3345 FALSE 24 40 F 3232 FALSE 19 40 F 2795 FALSE 20...
Second, the researcher wishes to use graphical descriptive methods to present summaries of the data on...
Second, the researcher wishes to use graphical descriptive methods to present summaries of the data on each of the two variables: hours worked per week and income earned per year, as stored in HOURSWORKED63 worksheet. c. Draw and display a histogram for each of the two variables using appropriate BIN values from part (b) and comment on the shape of the two distributions. Data for HOURSWORKED63 Excel spreadsheet is below: Yearly Income ('000's) Hours Per Week 43.8 18 44.5 13...
Using If and LookUp Formulas Formatting Grades Input boxes in tan Output boxes in yellow Given...
Using If and LookUp Formulas Formatting Grades Input boxes in tan Output boxes in yellow Given data in blue Answers in red Professor Streterstein is a bit absentminded. His instructor’s grade book is a mess, and he would like your help cleaning it up and making it easier to use. In Professor Streterstein’s course, the maximum possible points a student can earn is 750. The following table displays the grade equivalent to total points for the course. Professor Streterstein's Course...
Use Stats Disk if needed!! Question= Based on this data, create an interval for which we...
Use Stats Disk if needed!! Question= Based on this data, create an interval for which we would consider it "usual" for a randomly selected participant to fall within. 1-6 2-1 3-1 4-4 5-6 6-8 7-2 8-2 9-4 10-5 11-7 12-10 13-6 14-3 15-2 16-1 17-Something ............. 18-1 19-2 20-3 21-5 22-7 23-8 24-2 25-3 26-2 27-2 28-4 29-3 30-4 31-6 32-1 33-1 34-6 35-4 36-4 37-3 38-1 39-1 40-5 41-8 42-1 43-7 44-9 45-2 46-9 47-7 48-8 49-4 .......... 50-2
The attached printout of an Excel spreadsheet shows the use of six financial formulas related to...
The attached printout of an Excel spreadsheet shows the use of six financial formulas related to the time-value-of-money concepts discussed in Chapter 5. Your task is to reproduce the spreadsheet using Excel financial formulas in the red cells, which have the names shown in blue in the adjacent cells. You can find the financial formulas in Excel by clicking on Formulas at the top of the spreadsheet, and then clicking on Financial. You will submit your spreadsheet through D2L, and...
USE STATSDISK if needed Question? "Based on this data below, create an interval for which we...
USE STATSDISK if needed Question? "Based on this data below, create an interval for which we would consider it "usual" for a randomly selected participant to fall within." ? Data Given: 1-6 2-1 3-1 4-4 5-6 6-8 7-2 8-2 9-4 10-5 11-7 12-10 13-6 14-3 15-2 16-1 17-Something ................ 18-1 19-2 20-3 21-5 22-7 23-8 24-2 25-3 26-2 27-2 28-4 29-3 30-4 31-6 32-1 33-1 34-6 35-4 36-4 37-3 38-1 39-1 40-5 41-8 42-1 43-7 44-9 45-2 46-9 47-7 48-8...
e SAT and the ACT are the two major standardized tests that colleges use to evaluate...
e SAT and the ACT are the two major standardized tests that colleges use to evaluate candidates. Most students take just one of these tests. However, some students take both. The data data76.dat gives the scores of 60 students who did this. How can we relate the two tests? (a) Plot the data with SAT on the x axis and ACT on the y axis. Describe the overall pattern and any unusual observations. (b) Find the least-squares regression line and...
The SAT and the ACT are the two major standardized tests that colleges use to evaluate...
The SAT and the ACT are the two major standardized tests that colleges use to evaluate candidates. Most students take just one of these tests. However, some students take both. The data data18.dat gives the scores of 60 students who did this. How can we relate the two tests? (a) Plot the data with SAT on the x axis and ACT on the y axis. Describe the overall pattern and any unusual observations. (b) Find the least-squares regression line and...
The SAT and the ACT are the two major standardized tests that colleges use to evaluate...
The SAT and the ACT are the two major standardized tests that colleges use to evaluate candidates. Most students take just one of these tests. However, some students take both. The data data141.dat gives the scores of 60 students who did this. How can we relate the two tests? (a) Plot the data with SAT on the x axis and ACT on the y axis. Describe the overall pattern and any unusual observations. (b) Find the least-squares regression line and...
Using the class sample data, analyze the student heights by completing the following. Please note the...
Using the class sample data, analyze the student heights by completing the following. Please note the following directions. The data below was collected from a group of 45 female students last semester. You will use this data throughout the semester on your lab assignments. Student # Gender Height Shoe Age Hand 1 F 68 8.5 20 R 2 F 60 5.5 27 R 3 F 64 7 31 R 4 F 67 7.5 19 R 5 F 65 8 20...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT