Question

DATA COLLECTION 65.9 50.1 70 78.2 60.6 72.6 46 87 88.2 76 87.3 98.9 96.6 65.9...

DATA COLLECTION

65.9
50.1
70
78.2
60.6
72.6
46
87
88.2
76
87.3
98.9
96.6
65.9
34.9
76.9
87.9
69.8
91.3
51.7
86.5
65.5
34
98.9
67.8
65.9
45
76.9
45.8
98.5
65.9
68.9
70.9
65.7
98.8
66.9
67.2
49.8
65.8
98.6
56.8
98.5
65.9
56.7
87.6
34.7
65.9
95.8
78.9
98.6
56.9
28.9
55.7
78
98
90
90.9
59.9
78
48.9
87.9
89
88
56.9
56.7
74.8
94.7
89.5
72.6
38.9
68.9
98.9
56.8
74.8
34.8
98.8
34.7
98.7
99.8
76.9
94.7
88.9
85.9
83
89.6
78.9
70
73.9
68
67.8
87.9
98.9
93.6
91.6
97
55.9
55.9
96.9
29
76.9

Use Excel, or any statistical software, to generate an exploratory analysis of the sample, including:

  1. Summary of descriptive statistics
  2. Histogram
  3. Boxplot
  4. Ogive
Math   Statistics-And-Probability   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

Sol:

in excel instal analysis tool pak

go to data >data analysis>summary statistics

select the data

You will get

Descriptive statistic

sample
Mean 73.601
Standard Error 1.937464
Median 74.8
Mode 65.9
Standard Deviation 19.37464
Sample Variance 375.3769
Kurtosis -0.5961
Skewness -0.4858
Range 70.9
Minimum 28.9
Maximum 99.8
Sum 7360.1
Count 100

For histogram in excel go to insert>histogram

Then

For boxplot

Insert box & whisker

no outliers seen from boxplot

Min=28.9

Q1=60.075

Q2=74.8

Q3=89.575

Max=99.8

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Construct a Frequency Distribution for Weight measurement for the given data. Choose a convenient class, class...
Construct a Frequency Distribution for Weight measurement for the given data. Choose a convenient class, class width and determine their frequencies and relative frequencies. Write a short note describing your frequency distribution table. WEIGHT 54.4 80.3 59.5 85.5 83.1 95.1 64.1 71.3 75.3 91.7 89.9 99.8 84.1 83.3 99.4 77.5 83.0 84.5 65.3 84.8 98.2 81.4 105.5 123.9 65.3 95.8 46.3 48.5 60.8 105.1 101.8 79.2 76.6 107.4 74.6 63.4 62.4 63.6 52.1 90.3 69.1 79.1 74.2 90.7 86.5 91.1...
Write the null hypotheses being tested Run the analysis either by using data analysis and the...
Write the null hypotheses being tested Run the analysis either by using data analysis and the two-sample test or by comparing the two confidence intervals Interpret your data to determine if the resting male heart rate is the same as the resting female heart rate. Remember we are looking for whether the difference is a significant one, not just whether they are not the same. 0 60.1 78.0 0 67.7 79.4 0 80.3 93.4 0 85.2 97.7 0 86.3 99.7...
Sort the quantitative variables by class (e.g., Male at-rest heart rate and Female at-rest heart rate)...
Sort the quantitative variables by class (e.g., Male at-rest heart rate and Female at-rest heart rate) Use the Excel Data Analysis ToolPak* tools to calculate each of the following statistics: Mean of each quantitative variable Sample variance of each quantitative variable Sample standard deviation of each quantitative variable Create a table in Excel that summarizes the statistics for each variable. Heart rate before and after exercise M=0 F=1 Resting After Exercise 0 60.1 78.0 0 67.7 79.4 0 80.3 93.4...
PULSE   WEIGHT 36   54.4 40   80.3 42   59.5 44   85.5 50   83.1 50   95.1 52   64.1...
PULSE   WEIGHT 36   54.4 40   80.3 42   59.5 44   85.5 50   83.1 50   95.1 52   64.1 52   71.3 52   75.3 52   91.7 52   89.9 52   99.8 54   84.1 54   83.3 54   99.4 54   77.5 54   83.0 54   84.5 54   65.3 54   84.8 56   98.2 56   81.4 56   105.5 56   123.9 56   65.3 56   95.8 56   46.3 56   48.5 56   60.8 56   105.1 56   101.8 58   79.2 58   76.6 58   107.4 58   74.6 58   63.4 58   62.4 58   63.6 58   52.1...
Evaluation Title: Assignment 6 Rubric Instructions: In this assignment, you will use the confidence intervals calculated...
Evaluation Title: Assignment 6 Rubric Instructions: In this assignment, you will use the confidence intervals calculated in Unit 5 to determine if two means are the same. Steps: Identify the means and confidence intervals for the resting heart rate for men and women. Use the 95% confidence intervals to determine if the resting male mean is the same as the resting female mean. Repeat the comparison for the 99% confidence interval. Explain why you think the two means are or...
In this assignment, you will be required to use the Heart Rate Dataset to complete the...
In this assignment, you will be required to use the Heart Rate Dataset to complete the following: Identify the types of data represented by variables The range or types of values for each variable Give a brief written description of the variables, and how they are used in the data set. Steps: Open the Heart Rate Dataset in Excel Identify each of the variables contained in the dataset by type Identify the type of data each variable represents (e.g., qualitative...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT