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

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)

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