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 rectangular gate shown in figure rotates about an axis through N. If a=3.3 ft,b=1.3 ft, d=2 ft, and the width perpendicular to the plane of the figure is 3 ft, what torque(applied to the shaft through N) is required to hold the gate closed?
An elevated tank feeds a simple pipe system as shown. There is a fire hydrant atpoint C. The minimum allowable pressure at point C is 22 psig for firefighting requirements.What are the maximum static head (in ft) as well as pressure (in psig) at point C (i.e. nodischarge in the system)? Do we meet the pressure requirement for firefighting? (Please donot worry about L or d in the figure below)
12. For the beam loaded and supported as shown, determine the following using Point Load Analogous via Integration: a. the rotation at the left support. b. the deflection at midspan R1 1 . m 600 N/m 3 m + 2 m R2
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