Concept explainers
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
Create a histogram for the test scores of an engineering class students using Excel.
Explanation of Solution
Given data:
Number of students,
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 |
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
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?
Chapter 19 Solutions
EBK ENGINEERING FUNDAMENTALS: AN INTROD
- Determine the location a of the centroid C of the shaded area that is part of a circle having a radius r = 0.3 m. Take a = 45° (Figure 1) Express your answer to three significant figures and include the appropriate units. HẢ ? Value Units Submit Previous Answers Request Answer X Incorrect; Try Again; 4 attempts remaining Figure Provide Feedbackarrow_forward15. The table below shows the number of hours ten students spent studying for a test and their scores. Hours Spent Studying (x) | 0 | 1 | 2 4 | 4 | 4 | 6 | 6 | 7 8 Test Scores (y) 35 40 46 65 | 67 70 82 88 82 95 Write the linear regression equation for this data set. Round all values to the nearest hundredth. State the correlation coefficient of this line, to the nearest hundredth. Explain what the correlation coefficient suggests in the context of the problem.arrow_forwardI Review the body relative to the cross-section. Consider the pipe assembly shown in (Figure 1). Neglect the weight of the pipe. Take F1 = {200 i – 200 j – 200 k} N and F2 = {200 i + 500 j} N. Express your answers using three significant figures separated by a comma. %3D Vy, Vz = -300,200 N Submit Previous Answers Correct Part C Determine the x, y, and z components of internal moment acting at a section passing through point B on the left part of the body relative to the cross-section. Figure 1 of 1 Express your answers using three significant figures separated by commas. vec Mg, My, M; = 400, – 300,200 N·m F, B Submit Previous Answers Request Answer X Incorrect; Try Again; 4 attempts remaining 1.5 m Provide Feedback Next >arrow_forward
- Read the question carefully and give me right solution according to the question. Note: Given end of the question n=0.02 not the graded questionarrow_forwardUse the data provided to complete the MVR table and determine the engineering parameters listed below. Write all answers for the MVR table to two decimal place and write all the answers for the engineering parameters (w, e, n. S. PT.PD) to two decimal places as a real number (i.e. no %). Be consistent with the units provided but do not include the units in your answer. VOLUME (ft³) Va = Blank 1 ft³ Vw = Blank 2 ft³ Vs = Blank 4 ft³ Vt = 0.14 ft³ water content = 13% porosity = Blank 6 void ratio = Blank 7 saturation = Blank 8 Total unit weight (lb/ft ³) = Blank 9 Dry unit weight (lb/ft ³) = Blank 10 AIR WATER 62.3 lb/ft³ SOLIDS G.S. = 2.75 WEIGHT (lb) Ww = Blank 3 lb Ws = Blank 5 lb Wt = 17 lbarrow_forwardConsider the cross-sectional area shown in (Figure 1). Suppose that h = 90 mm Figure 25 mm---- 50 mm 150 mm ---25 mm 50 mm 25 mm 1 of 1 Part A Determine the location of the centroid for the cross-sectional area. Express your answer to three significant figures and include the appropriate units. ÿ= Value Submit LA Provide Feedback Request Answer Units ?arrow_forward
- You are to write down on a piece of paper the number of credits you are taking this semester. Your instructor will then collect the data and share the results with the class. Calculate the mean and standard deviation of the data. Assuming a normal distribution, determine the probability that a student is taking between 12 to 15 credits this semester. What is the probability that a student is taking less than 12 credits?arrow_forwardImagine that you and four of your classmates have measured the density of air and recorded the values shown in the accompanying table. Determine the average, variance, and standard deviation for the measured density of air. Density of Air (kg/m3) 1.27 1.21 1.28 1.25 1.24arrow_forward3.Please answer the question in a complete. Write the given, required, figure, formula that will used/had been use. And box the final answer. Thank youarrow_forward
- Using Double Integration Method, Please help me solve the three questions. I'll rate. please box your final answers. all three decimals only.arrow_forwardI answered this question, but unfortunately, my answer was wrong. However, this is the correct answer. Please help me come up with a calculation to get these answer. The correct answer is 8.58. Cheersarrow_forwardA person by the name of Huebscher developed a relationship between theequivalent size of round ducts and rectangular ducts according to D = diameter of equivalent circular duct (mm)a = dimension of one side of the rectangular duct (mm)b = the other dimension of the rectangular duct (mm)Using Excel, create a table that shows the relationship between the circular and the rectangular duct dimensions, similar to the one shown in the accompanying table.arrow_forward
- Engineering Fundamentals: An Introduction to Engi...Civil EngineeringISBN:9781305084766Author:Saeed MoaveniPublisher:Cengage Learning