200 likes | 318 Vues
This document provides a comprehensive overview of engineering statistics relevant to students and administrators at SJSU. It covers essential topics such as plotting data in Excel, analyzing engineering enrollments, and calculating starting salaries based on historical data. Key questions explored include predicting future first-year enrollment using past data (1975-1980) and assessing error percentages in those predictions. Moreover, it highlights the significance of engineering degrees awarded and salary trends from the NACE Salary Survey.
E N D
A Statistical Profile of EngineeringNotes from Engineering Your Future, Ch4 Tom Rebold MPC
Questions from Last Class • In Excel, if you copy this formula, =$A4*B$5 and paste one cell to the right, what does the formula turn into ?
Agenda • Engineering Statistics • SJSU Plotting in Excel • SJSU Excel Lab 2 • Test 1
Some useful Stats from your Text • Engineering Enrollments • Degrees awarded by Discipline • Starting Salaries
If an administrator used only the data from 1975 to 1980 to predict future engineering enrollment, how many first-year, full-time students would have been expected in 2008? • What would the percentage error have been? • Error, % = 100*(Predicted – Actual) / Actual
NACE Salary Survey 2012http://www.naceweb.org/uploadedFiles/NACEWeb/Research/Salary_Survey/Reports/SS_ExecSummary_Sept2012.pdf