AE240_HW1_STEPS

.docx

School

Pennsylvania State University *

*We aren’t endorsed by this school

Course

221

Subject

Mechanical Engineering

Date

Feb 20, 2024

Type

docx

Pages

2

Uploaded by SuperHumanLightningMule45

Report
AE240 Excel Data Sheet Record of Steps & Data Interpretation Name: Brandon M. Miller Record of Code: 1) The first thing I did was get rid of the # symbol in front of the numbers. I proceeded by typing in the code “=SUBSTITUTE(A1, "#", "")” into column L. Following this, I copied the column and tried to do a “paste special” into column F but kept getting REF! Errors and realized that I needed to make sure I wasn’t deleting my reference when copying over to column F. The best way to get around this was by putting the REF column in L, as it wouldn’t interfere with the rest of the homework. 2) Making the graphs: To expedite the process of analyzing the data, I exported a photo of my Excel data into ChatGPT to create the graphs for me. I had it generate a VBA code based on my data and followed this by opening my workbook in Excel through Ctrl + F11, then inserting the code and running it with F5. I did this as I understand how to make the graphs manually, and felt it would be better to utilize my time understanding code I am still new at. Code in Workbook: 3) Last few codes: In finding the last bit of data, I wasn’t 100% sure how to exactly do it, so I asked ChatGPT questions on how I could correctly calculate the mean density and the
standard deviation (density). It gave me a few different options I could execute and taught me what they were used for, including “STEDEV.P” for the data set. With this, I manually typed the codes within the Excel that I learned how to do through ChatGPT. Given that I am a novice at any code, I find it to be helpful to utilize after trying to figure out how to do the code, and it is not working after 15 minutes. Codes used for calculation process with density and deviation: o =C2 / (PI() * (D2/2)^2 * 12) o =AVERAGE(E2:E13) o =STDEV.P(E2:E13) Interpretation of the Results: The results support that the ‘Diameter’ has the highest correlation with ‘Bar Size Designation’ when looking at the R-squared value. The mean density is consistent with the expected steel density, which is further supported by the marginal standard deviation, indicating the uniform material properties across the bar size.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help