Documents

Lab_1.xlsx

Description
141 1 Mark ID # Submission Date Problem 1 Problem 2 Problem 3 Problem 4 Total Student Name Problem # King Fahd University of Petroleum & Minerals Civil & Environmental Engineering Department CE 318 Numerical & Statistical Methods in Civil Engineering Academic Term Assignment # Instructor: Dr. Husain Jubran Al-Gahtani How to use Excel built-in functions Exercise 1 Fill-in the third column by computing the respective function given in the second column x Formula Result -1 Abs(x) 3.14 Cos(x) 3.14
Categories
Published
of 13
48
Categories
Published
All materials on our website are shared by users. If you have any questions about copyright issues, please report us to resolve them. We are always happy to assist you.
Similar Documents
Share
Transcript
  1411 Mark ID #Submission DateProblem 1Problem 2Problem 3Problem 4TotalStudent NameProblem # King Fahd University of Petroleum & Minerals ivil & Environmental Engineering Departme CE 318 Numerical & Statistical Methods in Civil Engineering Academic Term Assignment # Instructor: Dr. Husain Jubran Al-Gahtani  How to use Excel built-in functionsExercise 1 Fill-in the third column by computing the respective function given in the second columnxFormulaResult-1Abs(x)3.14Cos(x)3.14Sin(x) π pi()0.1Exp(x)2.5Even(x)2.5Odd(x)2.35Floor(x,a)2.35Ceiling(x,a)16Sqrt(x)0.5Atan(x)180RadiansAs an example, to use the SIN formula just write =(equal to) SIN followed by the number in brackets as shown in the figure. As soon as you close the brackets and hit enter the formula is evaluated and displayed in the same cell as shown in the figure. Note that you can use capital, small or mixed letters (Excel is not case-sensitive) Try more functions (many of them stored under Formulas menue  Repeating Calculations Create a table in which the first column is x, the second column is f(x) = x 2 +sin x +e x Repeat the caculations for x = 0.1, 0.2 to 1.2, then plot the data of x versus f(x) Add a third column containing the function x*f(x) to the data and add it to the plot xf(x)x*f(x)0.11.21500430.0012150.21.46007210.2920140.31.7353790.5206140.42.0412430.8164970.52.37814681.1890730.62.74676131.6480570.73.14797042.2035790.83.5828972.8663180.94.052933.64763714.55975284.5597531.15.10537345.6159111.25.6921566.830587 Exercise 2 -80 < x < 4V(x)=126 < x< 842-5x8 < x< 10-8x0 < x < 4M(x)12x-806 < x< 8 -2.5x^2+42x-170 8 < x< 10x (m)V (N)M (N.m)0-804-8-324.00112-31.988612-8771.58269-35.510-80The first column in the following table represents distance measured from the left end of a beam. The second column represents the shear force and the third represents the bending moment. Add another two columns that display the results of V and M, then plot them in one figure (x-axis the distance x and y-axis for shear V & moment M). Can you add a y-axis for the moment so that it has a more suitable scale. (Hint:right mouse-click on the moment curve -> Format data series -> select Soon (in this lab) you will learn a more efficient way of formulating the shear and moment using IF statement 01234567800.511.5f(x)x*f(x)  You should get the following results -35-30-25-20-15-10-5051015051015Shear (N)Bending Moment(N.m)-35-30-25-20-15-10-50510-10-5051015051015Shear (N)Bending Moment(N.m)

Genomic Imprinting

Jul 24, 2017
We Need Your Support
Thank you for visiting our website and your interest in our free products and services. We are nonprofit website to share and download documents. To the running of this website, we need your help to support us.

Thanks to everyone for your continued support.

No, Thanks
SAVE OUR EARTH

We need your sign to support Project to invent "SMART AND CONTROLLABLE REFLECTIVE BALLOONS" to cover the Sun and Save Our Earth.

More details...

Sign Now!

We are very appreciated for your Prompt Action!

x