ENGINEERING FUNDAMENTALS
ENGINEERING FUNDAMENTALS
6th Edition
ISBN: 9781337705011
Author: MOAVENI
Publisher: CENGAGE L
bartleby

Concept explainers

bartleby

Videos

Textbook Question
Book Icon
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
Check Mark
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

ScoresRangeFrequency (f)
57, 55, 58, 51, 5250-595
66, 62, 61, 66, 66, 6360-696
77, 75, 78, 74, 72, 70, 75, 73, 79, 7770-7910
81, 86, 87, 82, 88, 8480-896
94, 97, 9190-993

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 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 anduse 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 Calculate the cumulative frequency and plot a cumulative-frequency polygon.
I. Calculate the mean, median, mode, standard deviation and the variance of the scores obtained by 90 applicants for employment, as shown on the table below. Prepare a separate table for each measure and use 5 as the class size. Scores of 90 applicants for employment Scores f 41 - 45 5 46 – 50 10 51 - 55 18 56 – 60 25 61 – 65 17 66 – 70 71 - 75 2/3
For the data listed in the table below, which shows the grades obtained by students in the engineering statistics subject in the Civil Engineering Department, find the following:۔ - The arithmetic mean, median and mode ..   Categories (degrees)=91 - 100 Frequency=2   Categories (degrees)=81 - 90 Frequency =4 Categories (degrees)=71 - 80 Frequency =9  Categories (degrees)=61 - 70 Frequency =15 Categories (degrees)=51 - 60 Frequency =10 Categories (degrees)=41 - 50 Frequency=6 Categories (degrees)=31 - 40 Frequency =4
Knowledge Booster
Background pattern image
Civil Engineering
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, civil-engineering and related others by exploring similar questions and additional content below.
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Engineering Fundamentals: An Introduction to Engi...
Civil Engineering
ISBN:9781305084766
Author:Saeed Moaveni
Publisher:Cengage Learning
What Is A Construction Takeoff? | Are They Still Necessary In Quantity Surveying?; Author: Metroun Quantity Surveying;https://www.youtube.com/watch?v=uTWoDPtcOjg;License: Standard Youtube License