22.302 Experiment #1 Numerical Methods Using （22.302实验# 1使用数值方法）.pdfVIP

22.302 Experiment #1 Numerical Methods Using Excel Introduction Excel is a spreadsheet software package that can be used for data reduction, analysis, and presentation. Throughout the mechanical engineering laboratory course sequence, Excel can be used to perform least squares curve fitting, numerical differentiation, numerical integration, and experimental data analysis. The purpose of this experiment is to perform linear regression analysis on experimental calibration data. Numerical differentiation will be performed on displacement and time data obtained from a free falling weight. This will result in the determination of the objects acceleration. The rectangular or trapezoidal rule of numerical integration will be used to determine the root mean square value of a computer generated sinusoidal wave. Integration of the acceleration of a vibrating structure, resulting in the determination of the objects displacement as a function of time, will be accomplished using the trapezoidal rule. Pre-Lab Assignment Read Section 6.6, 6.7, 6.8 in the Wheeler and Ganji text, and solve problems 6.61 and 6.62. Hand in the prelab along with the report for this lab as an appendix. Assignment #1: Excel File Retrieval for Assignments Copy the three files (lab1-A.xls, lab1-B.xls, lab1-C.xls) needed for this experiment from the hard drive of the ME Lab computers, webpage or CD. Microsoft Excel will be used for processing data. Assignment #2: Least Squares Regression Least squares regression is a statistical means of determining the relationship between independent and dependent variables. In this assignment, data obtained from the calibration of a turbine flow meter will be analyzed. An equation of the form y = mx + b will be determined, compared, and plotted against experimental data. Procedure 1. Retrieve the file lab