Question

In excel, calculate the frequency given the bins. The data is shown below. Also, provide the...

In excel, calculate the frequency given the bins. The data is shown below. Also, provide the excel formula.

2.0
-61.0
-9.0
14.0
43.0
-16.0
-11.0
8.0
20.0
-15.0
0.0
-37.0
9.0
14.0
40.0
-29.0
38.0
-49.0
65.0
27.0
89.0
-16.0
83.0
72.0
-3.0
-21.0
51.0
36.0
26.0
-45.0
-6.0
14.0
-3.0
55.0
39.0
-6.0
-35.0
25.0
27.0
6.0
12.0
37.0
-12.0
35.0
24.0
15.0
35.0
-67.0
2.0
-32.0
-34.0
-32.0
22.0
51.0
33.0
10.0
-28.0
2.0
12.0
17.0
44.0
-29.0
22.0
-28.0
-18.0
-12.0
-19.0
11.0
62.0
50.0
-27.0
46.0
62.0
-26.0
-54.0
-61.0
45.0
-51.0
-41.0
14.0
9.0
-56.0
0.0
-34.0
-52.0
-28.0
14.0
63.0
23.0
-46.0
29.0
1.0
1.0
20.0
1.0
25.0
-4.0
29.0
-15.0
78.0

  

Frequency Distribution
Low High Bins Frequency
-67.0 -56.6 (-67, -56.6]
-56.6 -46.2 (-56.6, -46.2]
-46.2 -35.8 (-46.2, -35.8]
-35.8 -25.4 (-35.8, -25.4]
-25.4 -15.0 (-25.4, -15]
-15.0 -4.6 (-15, -4.6]
-4.6 5.8 (-4.6, 5.8]
5.8 16.2 (5.8, 16.2]
16.2 26.6 (16.2, 26.6]
26.6 37.0 (26.6, 37]
37.0 47.4 (37, 47.4]
47.4 57.8 (47.4, 57.8]
57.8 68.2 (57.8, 68.2]
68.2 78.6 (68.2, 78.6]
78.6 89.0 (78.6, 89]
89.0 99.4 (89, 99.4]
Math   Statistics-And-Probability   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

Solution:

Here we have to find the frequency of given data as below

Frequency Distribution
Low High Bins Frequency
-67 -56.6 (-67, -56.6] 3
-56.6 -46.2 (-56.6, -46.2] 5
-46.2 -35.8 (-46.2, -35.8] 4
-35.8 -25.4 (-35.8, -25.4] 12
-25.4 -15 (-25.4, -15] 7
-15 -4.6 (-15, -4.6] 6
-4.6 5.8 (-4.6, 5.8] 11
5.8 16.2 (5.8, 16.2] 14
16.2 26.6 (16.2, 26.6] 10
26.6 37 (26.6, 37] 9
37 47.4 (37, 47.4] 7
47.4 57.8 (47.4, 57.8] 4
57.8 68.2 (57.8, 68.2] 4
68.2 78.6 (68.2, 78.6] 2
78.6 89 (78.6, 89] 2
89 99.4 (89, 99.4] 0

Thank You..!!

I give my 100% hope you satisfied with my answer Please like it ..

I am waiting for feedback ...!!

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
We wish to determine the impact of Specification Buying, X11, on Satisfaction Level, X10. To do...
We wish to determine the impact of Specification Buying, X11, on Satisfaction Level, X10. To do so we will split the Hatco data file into two separate data sets based on the Specification Buying, X11. This variable has two categories: 1=employs total value analysis approach, evaluating each purchase separately; 0 = use of specification buying. Sort the entire Hatco data set based on Specification Buying. This will create two separate groups of records. Those records with X11 = 0 and...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT