The scores of a test for an engineering class of 30 students are shown here. Organize the data in a manner similar to Table 19.1 and use Excel to create a histogram. Scores: 57, 94, 81, 77, 66, 97, 62, 86, 75, 87, 91, 78, 61, 82, 74, 72, 70, 88, 66, 75, 55, 66, 58, 73, 79, 51, 63, 77, 52, 84

Question

Want to see more full solutions like this?

Answer 1

Textbook Question

Chapter 19, Problem 1P

The scores of a test for an engineering class of 30 students are shown here. Organize the data in a manner similar to Table 19.1 and use Excel to create a histogram.

Scores: 57, 94, 81, 77, 66, 97, 62, 86, 75, 87, 91, 78, 61, 82, 74, 72, 70, 88, 66, 75, 55, 66, 58, 73, 79, 51, 63, 77, 52, 84

Expert Solution & Answer

To determine

Create a histogram for the test scores of an engineering class students using Excel.

Explanation of Solution

Given data:

Number of students, $n=30$ .

Students test scores are 57, 94, 81, 77, 66, 97, 62, 86, 75, 87, 91, 78, 61, 82, 74, 72, 70, 88, 66, 75, 55, 66, 58, 73, 79, 51, 63, 77, 52, 84.

Calculation:

The given test scores are organized in a grouped frequency distribution manner which is shown in Table 1. In the distribution, the frequency represents the number of test scores in a given range.

Table 1

Scores	Range	Frequency $(f)$
57, 55, 58, 51, 52	50-59	5
66, 62, 61, 66, 66, 63	60-69	6
77, 75, 78, 74, 72, 70, 75, 73, 79, 77	70-79	10
81, 86, 87, 82, 88, 84	80-89	6
94, 97, 91	90-99	3

Draw the histogram for the students test scores for the respective frequency $(f)$ value in Excel sheet by selecting the two columns of “range” and “frequency” and go to “insert tab” and click “column bar chart” and select “2-D column”, then the graph will be plotted as shown in Figure 1.

ENGINEERING FUNDAMENTALS, Chapter 19, Problem 1P

Therefore, the histogram for the test scores of engineering class students is shown in Figure 1.

Conclusion:

Thus, the histogram for the test scores of an engineering class students has been created using Excel.

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Students have asked these similar questions

The following data show spot speeds collected at a section of highway located in a residential area before and after an increase in speed enforcement activities. (All speeds are in mi/h.) Before After Before After 44 27 34 21 38 36 35 21 36 23 32 37 41 40 26 26 36 40 38 33 28 32 41 23 32 27 31 24 38 31 36 23 33 22 36 26 44 35 29 23 36 27 31 20 33 18 38 22 40 25 31 26 39 31 33 32 38 33 41 35 Using the student's t-test, determine whether there was a statistically significant difference in the average speeds at a significance level of a = 0.05 (the 95-percent confidence level.) O Yes, there was a statistically significant difference in the average speeds. ○ No, there was not a statistically significant difference in the average speeds. Also report, for both the before and after cases, the mean speed, standard deviation, 85th-percentile speed, and percentage of traffic exceeding the posted speed limit of 30 mi/h. (Enter all speeds and standard deviations in mi/h. Round your 85th-percentile…

Calculate the BMs (bending moments) at all the joints of the beam shown in Fig.1 using the moment distribution method. The beam is subjected to an UDL of w=65m. L=4.5m L1= 1.8m. Assume the support at C is pinned, and A and B are roller supports. E = 200 GPa, I = 250x106 mm4.

||| = 1% 11. LTE2 Voi) Vol) 1. LTE1 SEARCH 8 VYT bartleby.com/dashboard ASK √x MATH SOLV affected resale value at year 5, would that affect perceived value-in-use? How exactly? There is an error in submission of question Check it out! See if this is the solution you're looking for VIEW FULL SOLUTION Not what you're looking for? Keep submitting your original question SUBMIT QUESTION

Answer 2

Textbook Question

Chapter 19, Problem 1P

The scores of a test for an engineering class of 30 students are shown here. Organize the data in a manner similar to Table 19.1 and use Excel to create a histogram.

Scores: 57, 94, 81, 77, 66, 97, 62, 86, 75, 87, 91, 78, 61, 82, 74, 72, 70, 88, 66, 75, 55, 66, 58, 73, 79, 51, 63, 77, 52, 84

Expert Solution & Answer

To determine

Create a histogram for the test scores of an engineering class students using Excel.

Explanation of Solution

Given data:

Number of students, $n=30$ .

Students test scores are 57, 94, 81, 77, 66, 97, 62, 86, 75, 87, 91, 78, 61, 82, 74, 72, 70, 88, 66, 75, 55, 66, 58, 73, 79, 51, 63, 77, 52, 84.

Calculation:

The given test scores are organized in a grouped frequency distribution manner which is shown in Table 1. In the distribution, the frequency represents the number of test scores in a given range.

Table 1

Scores	Range	Frequency $(f)$
57, 55, 58, 51, 52	50-59	5
66, 62, 61, 66, 66, 63	60-69	6
77, 75, 78, 74, 72, 70, 75, 73, 79, 77	70-79	10
81, 86, 87, 82, 88, 84	80-89	6
94, 97, 91	90-99	3

Draw the histogram for the students test scores for the respective frequency $(f)$ value in Excel sheet by selecting the two columns of “range” and “frequency” and go to “insert tab” and click “column bar chart” and select “2-D column”, then the graph will be plotted as shown in Figure 1.

ENGINEERING FUNDAMENTALS, Chapter 19, Problem 1P

Therefore, the histogram for the test scores of engineering class students is shown in Figure 1.

Conclusion:

Thus, the histogram for the test scores of an engineering class students has been created using Excel.

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Answer 3

Textbook Question

Chapter 19, Problem 1P

The scores of a test for an engineering class of 30 students are shown here. Organize the data in a manner similar to Table 19.1 and use Excel to create a histogram.

Scores: 57, 94, 81, 77, 66, 97, 62, 86, 75, 87, 91, 78, 61, 82, 74, 72, 70, 88, 66, 75, 55, 66, 58, 73, 79, 51, 63, 77, 52, 84

Expert Solution & Answer

To determine

Create a histogram for the test scores of an engineering class students using Excel.

Explanation of Solution

Given data:

Number of students, $n=30$ .

Students test scores are 57, 94, 81, 77, 66, 97, 62, 86, 75, 87, 91, 78, 61, 82, 74, 72, 70, 88, 66, 75, 55, 66, 58, 73, 79, 51, 63, 77, 52, 84.

Calculation:

The given test scores are organized in a grouped frequency distribution manner which is shown in Table 1. In the distribution, the frequency represents the number of test scores in a given range.

Table 1

Scores	Range	Frequency $(f)$
57, 55, 58, 51, 52	50-59	5
66, 62, 61, 66, 66, 63	60-69	6
77, 75, 78, 74, 72, 70, 75, 73, 79, 77	70-79	10
81, 86, 87, 82, 88, 84	80-89	6
94, 97, 91	90-99	3

Draw the histogram for the students test scores for the respective frequency $(f)$ value in Excel sheet by selecting the two columns of “range” and “frequency” and go to “insert tab” and click “column bar chart” and select “2-D column”, then the graph will be plotted as shown in Figure 1.

ENGINEERING FUNDAMENTALS, Chapter 19, Problem 1P

Therefore, the histogram for the test scores of engineering class students is shown in Figure 1.

Conclusion:

Thus, the histogram for the test scores of an engineering class students has been created using Excel.

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Answer 4

Textbook Question

Chapter 19, Problem 1P

The scores of a test for an engineering class of 30 students are shown here. Organize the data in a manner similar to Table 19.1 and use Excel to create a histogram.

Scores: 57, 94, 81, 77, 66, 97, 62, 86, 75, 87, 91, 78, 61, 82, 74, 72, 70, 88, 66, 75, 55, 66, 58, 73, 79, 51, 63, 77, 52, 84

Expert Solution & Answer

To determine

Create a histogram for the test scores of an engineering class students using Excel.

Explanation of Solution

Given data:

Number of students, $n=30$ .

Students test scores are 57, 94, 81, 77, 66, 97, 62, 86, 75, 87, 91, 78, 61, 82, 74, 72, 70, 88, 66, 75, 55, 66, 58, 73, 79, 51, 63, 77, 52, 84.

Calculation:

The given test scores are organized in a grouped frequency distribution manner which is shown in Table 1. In the distribution, the frequency represents the number of test scores in a given range.

Table 1

Scores	Range	Frequency $(f)$
57, 55, 58, 51, 52	50-59	5
66, 62, 61, 66, 66, 63	60-69	6
77, 75, 78, 74, 72, 70, 75, 73, 79, 77	70-79	10
81, 86, 87, 82, 88, 84	80-89	6
94, 97, 91	90-99	3

Draw the histogram for the students test scores for the respective frequency $(f)$ value in Excel sheet by selecting the two columns of “range” and “frequency” and go to “insert tab” and click “column bar chart” and select “2-D column”, then the graph will be plotted as shown in Figure 1.

ENGINEERING FUNDAMENTALS, Chapter 19, Problem 1P

Therefore, the histogram for the test scores of engineering class students is shown in Figure 1.

Conclusion:

Thus, the histogram for the test scores of an engineering class students has been created using Excel.

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Answer 5

Textbook Question

Answer 6

Textbook Question

Answer 7

Expert Solution & Answer

To determine

Create a histogram for the test scores of an engineering class students using Excel.

Explanation of Solution

Given data:

Number of students, $n=30$ .

Students test scores are 57, 94, 81, 77, 66, 97, 62, 86, 75, 87, 91, 78, 61, 82, 74, 72, 70, 88, 66, 75, 55, 66, 58, 73, 79, 51, 63, 77, 52, 84.

Calculation:

The given test scores are organized in a grouped frequency distribution manner which is shown in Table 1. In the distribution, the frequency represents the number of test scores in a given range.

Table 1

Scores	Range	Frequency $(f)$
57, 55, 58, 51, 52	50-59	5
66, 62, 61, 66, 66, 63	60-69	6
77, 75, 78, 74, 72, 70, 75, 73, 79, 77	70-79	10
81, 86, 87, 82, 88, 84	80-89	6
94, 97, 91	90-99	3

Draw the histogram for the students test scores for the respective frequency $(f)$ value in Excel sheet by selecting the two columns of “range” and “frequency” and go to “insert tab” and click “column bar chart” and select “2-D column”, then the graph will be plotted as shown in Figure 1.

ENGINEERING FUNDAMENTALS, Chapter 19, Problem 1P

Therefore, the histogram for the test scores of engineering class students is shown in Figure 1.

Conclusion:

Thus, the histogram for the test scores of an engineering class students has been created using Excel.

Answer 8

Expert Solution & Answer

To determine

Create a histogram for the test scores of an engineering class students using Excel.

Explanation of Solution

Given data:

Number of students, $n=30$ .

Students test scores are 57, 94, 81, 77, 66, 97, 62, 86, 75, 87, 91, 78, 61, 82, 74, 72, 70, 88, 66, 75, 55, 66, 58, 73, 79, 51, 63, 77, 52, 84.

Calculation:

The given test scores are organized in a grouped frequency distribution manner which is shown in Table 1. In the distribution, the frequency represents the number of test scores in a given range.

Table 1

Scores	Range	Frequency $(f)$
57, 55, 58, 51, 52	50-59	5
66, 62, 61, 66, 66, 63	60-69	6
77, 75, 78, 74, 72, 70, 75, 73, 79, 77	70-79	10
81, 86, 87, 82, 88, 84	80-89	6
94, 97, 91	90-99	3

Draw the histogram for the students test scores for the respective frequency $(f)$ value in Excel sheet by selecting the two columns of “range” and “frequency” and go to “insert tab” and click “column bar chart” and select “2-D column”, then the graph will be plotted as shown in Figure 1.

ENGINEERING FUNDAMENTALS, Chapter 19, Problem 1P

Therefore, the histogram for the test scores of engineering class students is shown in Figure 1.

Conclusion:

Thus, the histogram for the test scores of an engineering class students has been created using Excel.

Answer 9

Expert Solution & Answer

Answer 10

Expert Solution & Answer

Answer 11

To determine

Create a histogram for the test scores of an engineering class students using Excel.

Answer 12

Explanation of Solution

Given data:

Number of students, $n=30$ .

Students test scores are 57, 94, 81, 77, 66, 97, 62, 86, 75, 87, 91, 78, 61, 82, 74, 72, 70, 88, 66, 75, 55, 66, 58, 73, 79, 51, 63, 77, 52, 84.

Calculation:

The given test scores are organized in a grouped frequency distribution manner which is shown in Table 1. In the distribution, the frequency represents the number of test scores in a given range.

Table 1

Scores	Range	Frequency $(f)$
57, 55, 58, 51, 52	50-59	5
66, 62, 61, 66, 66, 63	60-69	6
77, 75, 78, 74, 72, 70, 75, 73, 79, 77	70-79	10
81, 86, 87, 82, 88, 84	80-89	6
94, 97, 91	90-99	3

Draw the histogram for the students test scores for the respective frequency $(f)$ value in Excel sheet by selecting the two columns of “range” and “frequency” and go to “insert tab” and click “column bar chart” and select “2-D column”, then the graph will be plotted as shown in Figure 1.

ENGINEERING FUNDAMENTALS, Chapter 19, Problem 1P

Therefore, the histogram for the test scores of engineering class students is shown in Figure 1.

Conclusion:

Thus, the histogram for the test scores of an engineering class students has been created using Excel.

Answer 13

Ch. 19.3 - Prob. 1BYG Ch. 19.3 - Prob. 2BYG Ch. 19.3 - Prob. 3BYG Ch. 19.3 - VocabularyState the meaning of the following...Ch. 19.5 - Prob. 1BYG Ch. 19.5 - Prob. 2BYG Ch. 19.5 - Prob. 3BYG Ch. 19.5 - Prob. 4BYG Ch. 19.5 - Prob. 5BYG Ch. 19.5 - Prob. BYGV

The scores of a test for an engineering class of 30 students are shown here. Organize the data in a manner similar to Table 19.1 and use Excel to create a histogram. Scores: 57, 94, 81, 77, 66, 97, 62, 86, 75, 87, 91, 78, 61, 82, 74, 72, 70, 88, 66, 75, 55, 66, 58, 73, 79, 51, 63, 77, 52, 84

Concept explainers

Videos

Explanation of Solution

Want to see more full solutions like this?

Chapter 19 Solutions