University:
Georgia Southern University
Course:
ENGR1121 | Computing in Mechanical Engineering
Academic year:

2024
Views:

382

Pages:

1
Author:

Jalen W.

ENGR1121 – Computing in Mechanical Engineering Lab Linear Algebraic Equations, Series Summations and Pivot Tables Lab due: end of lab Total points: 20 Labs are to be individual work. You may use the textbook, Excel’s help, and your notes. Lab work will be graded during lab time and working results must be shown to the lab instructor by the end of the scheduled lab time. All Excel Spreadsheets must be completed and submitted in accordance with the Computing Assignment Format. Submit an electronic copy of your lab work to the appropriate Dropbox Folder in GSU’s Folio by the end of lab. No hard copy needed unless specifically requested by the instructor. Grading Each problem will be graded according to: problem design (identifying inputs/givens, process, and outputs; algorithm) and program style (headers and comments, variable names, proper formatted input and output including units) 25%, and program correctness 75%. Lab Work Create an Excel Spreadsheet to do each of the following problems. Name the Excel Spreadsheet using the following naming scheme: lastnamelab1.xlsx Create a new Worksheet within the Spreadsheet for each problem. Name the Worksheet using the following naming scheme: Problem 1 or Problem 2.3 and so on 1. (5 points) Solve the following system of equations: 𝒙𝒙𝟏𝟏 − 𝟐𝟐𝒙𝒙𝟐𝟐 + 𝟑𝟑𝒙𝒙𝟑𝟑 = 𝟏𝟏𝟏𝟏 𝟑𝟑𝒙𝒙𝟏𝟏 + 𝒙𝒙𝟐𝟐 −𝟐𝟐𝟐𝟐𝟑𝟑 = 𝟎𝟎 𝟐𝟐𝒙𝒙𝟏𝟏 + 𝟑𝟑𝒙𝒙𝟐𝟐 + 𝒙𝒙𝟑𝟑 = 𝟕𝟕 2 (5 points) An electrical engineer supervises the production of three types of electrical components. Three kinds of material – metal, plastic and rubber - are required for production. The amounts needed to produce each component are shown in the table below. Metal g/component Component 1 15 Component 2 17 Component 3 19 Total of each material available per day (g/day) 3890 Plastic g/component 0.30 0.40 0.55 95 Rubber g/component 1.0 1.2 1.5 282 a. How many of each component can be produced per day? b. How many components (in total) can be produced per day? 𝟐𝟐 3. (5 points) Summation of a series: 𝒇𝒇 = ∑𝑵𝑵 𝒌𝒌=𝟏𝟏 𝟓𝟓𝒌𝒌 − 𝟐𝟐𝟐𝟐 a. Compute the summation of the series using N=15 terms. b. Determine how many terms, N, are required for f to not exceed 10000. 4. (5 points) Import the population data from the *.txt file. Create a pivot table to better organize the data. The pivot table must be properly formatted. 1 Instructor: Dr. Priya Goeser