Concept explainers
(a)
Using the Excel Help menu, demonstrate the proper use of given function TRUNC(number, num_digits) with a simple example.
(a)
Explanation of Solution
Open the spread sheet (excel sheet) go to file and select Help, it will displays “Microsoft office help”, now click on it, then a new pop-up displays with the name of “Excel Help”. Now in the search place Type ‘TRUNC’ and click search, it will display various syntax functions.
Now click on the function “TRUNC function”, it will be shown the article for TRUNC function and given excel function is,
TRUNC(number, num_digits).
That is, truncates a number to an integer by eliminating the fractional part of the number.
Example:
Consider the function as,
TRUNC(5.342,1)
Here,
5.342 is refer to the number, and
1 is refer to the num_digits.
Refer to Figure 1, type
Conclusion:
Hence, the proper use of given function with a simple example has been explained by using excel.
(b)
Using the Excel Help menu, demonstrate the proper use of given function ROUND(number, num_digits) with a simple example.
(b)
Explanation of Solution
Open the spread sheet (excel sheet) go to file and select Help, it will displays “Microsoft office help”, now click on it, then a new pop-up displays with the name of “Excel Help”. Now in the search place Type ‘ROUND’ and click search, it will display various syntax functions.
Now click on the function “ROUND function”, it will be shown the article for ROUND function and given excel function is,
ROUND(number, num_digits)
That is, rounds a number to a specified number of digits.
Example:
ROUND(5.34268,3)
Here,
5.34268is refer to the number, and
3 is refer to the num_digits.
Refer to Figure 2, type
Conclusion:
Hence, the proper use of given function with a simple example has been explained by using excel.
(c)
Using the Excel Help menu, demonstrate the proper use of given function COMBIN(number, num_chosen) with a simple example.
(c)
Explanation of Solution
Open the spread sheet (excel sheet) go to file and select Help, it will displays “Microsoft office help”, now click on it, then a new pop-up displays with the name of “Excel Help”. Now in the search place Type ‘COMBIN’ and click search, it will display various syntax functions.
Now click on the function “COMBIN function”, it will be shown the article for COMBIN function and given excel function is,
COMBIN(number, num_chosen)
That is, to determine the total possible number of groups for a given number of items.
Example:
Consider three cards namely A, B and C. From these three cards there are different ways to combine the card into groups of two. They are, Group1: A and B; Group 2: Aand C; Group 3: B and C; Using excel, COMBIN(3,2) is equal to 3. Here, 3 is referred to number and 2 is referred to num_chosen.
Refer to Figure 3, in cell A1, type the formula as written as “=COMBIN(3,2)” and press enter key. The result obtained in the cell A1as
And another example is take any 5 colors, to find the combinations of any of three colors from the 5, in excel it can be find by the formula “=COMBIN(5,3)”, which will results into 10 combinations as shown below Figure 4.
Conclusion:
Hence, the proper use of given function with a simple example has been explained by using excel.
(d)
Using the Excel Help menu, demonstrate the proper use of given function DEGREES(angle) with a simple example.
(d)
Explanation of Solution
Open the spread sheet (excel sheet) go to file and select Help, it will displays “Microsoft office help”, now click on it, then a new pop-up displays with the name of “Excel Help”. Now in the search place Type ‘DEGREES’ and click search, it will display various syntax functions.
Now click on the function “DEGREES function”, it will be shown the article for DEGREES function and given excel function is,
DEGREES(angle)
That is, converts radians into degrees.
Example:
DEGREES(3.141592)
Here,
3.141592 is refer to the angle in radians
Refer to Figure 5, type
Conclusion:
Hence, the proper use of given function with a simple example has been explained by using excel.
(e)
Using the Excel Help menu, demonstrate the proper use of given function SLOPE(known_y’s,known_x’s) with a simple example.
(e)
Explanation of Solution
Open the spread sheet (excel sheet) go to file and select Help, it will displays “Microsoft office help”, now click on it, then a new pop-up displays with the name of “Excel Help”. Now in the search place Type ‘SLOPE’ and click search, it will display various syntax functions.
Now click on the function “SLOPE function”, it will be shown the article for SLOPE function and given excel function is,
SLOPE(known_y’s,known_x’s)
That is, returns the slope of a line fit to a set of data points.
Example:
Consider the table for known_y’s and known_x’s values as shown in Table 1.
Table 1
y-value | x-value |
1 | 2 |
2 | 4 |
3 | 6 |
4 | 8 |
5 | 10 |
And show it is in excel file as follows,
Refer to Figure 6, type the values in the appropriate cell. Then, in cell A8, type the formula as written as “=SLOPE(A2:A6,B2:B6)” and press enter key. The result obtained in the cell A8as
Conclusion:
Hence, the proper use of given function with a simple example has been explained by using excel.
(f)
Using the Excel Help menu, demonstrate the proper use of given function CEILING(number,significance) with a simple example.
(f)
Explanation of Solution
Open the spread sheet (excel sheet) go to file and select Help, it will displays “Microsoft office help”, now click on it, then a new pop-up displays with the name of “Excel Help”. Now in the search place Type ‘CEILING’ and click search, it will display various syntax functions.
Now click on the function “CEILING function”, it will be shown the article for CEILING function and given excel function is,
CEILING(number,significance)
That is, rounds up to the nearest given significance.
Example:
CEILING(3.842,1)
Here,
3.842 is refer to the number, and
1 is refer to the significance.
Refer to Figure 7, type
Conclusion:
Hence, the proper use of given functions with a simple example has been explained by using excel.
Want to see more full solutions like this?
Chapter 14 Solutions
EBK ENGINEERING FUNDAMENTALS: AN INTROD
- Find the collapse load (Wu) for the one-end continuous beam shown below. Wu 6 marrow_forward4- As part of a highway interchange project, a ramp will be constructed to allow the vehicles exit the first highway and enter the second highway. The first highway runs north-south and the second one had a right angle to the first one (it runs east-west). Vehicles going to the north can use this exit ramp to enter the second highway as shown in the plan view in the figure below. The design speed in both highways is 100 km/hr. The stationing of the start of the horizontal curve is 40+00. a) Determine the stationing of PI and PT¶ b) The first highway has a vertical grade of +3.5% and the second highway has a grade of - 0.5%. The stationing of the beginning and the end of the crest curve are the same as the horizontal curve. What is the elevation of the end of the vertical curve (PVT) if the elevation of the start point (PVC) is 1500m c) Calculate K for the vertical curve Plan view (horizontal alignment) PT 1 N Profile view (vertical alignment) G1=0.5% PVT PC, 40+00 PVC G1=+3.5%arrow_forward10- A pavement with a thin bituminous surface is going to be constructed with a design traffic of 6*105 ESA. Laboratory testing of the subgrade and pavement materials has given the following CBR values. Design the pavement using the empirical design method. Use the and show how you got the numbers on the graph relevant graph} Subgrade CBR: 5 Granular subbase material: Upper layer CBR> 30 Lower layer CBR = 10 Granular base material CBR >100arrow_forward
- 1- Describe the perception-reaction process in driver's decision making. What are the steps this process consists of and what tasks are included in each step? Why this process should be considered in transportation planning 3- What are the three main parts that can be included in a road cross section? Briefly describe what each part is for? Sketch a typical cross sectionarrow_forwardNote: Please provide a clear, step-by-step simplified handwritten working out (no explanations!), ensuring it is done without any AI involvement. I require an expert-level answer, and I will assess and rate based on the quality and accuracy of your work and refer to the provided image for more clarity. Make sure to double-check everything for correctness before submitting appreciate your time and effort!.arrow_forward8- A granular pavement with thin bituminous surfacing is going to be constructed in a rural area and it is estimated that the average annual daily traffic will be 21,000 vehicles per day. The road will have 3 lanes in each direction. The survey data from the existing roads close to that area shows that 15% of the vehicles in the traffic stream are heavy and the rest are light. However, no details of heavy vehicle types are given. It is also estimated that the annual growth factor is 3.2%. Determine the design traffic (DESA) assuming that the damage index (ESA/HVAG) is 0.9 9- a) What are the three main distress modes in flexible pavements (3 points)? b) What are their likely causesarrow_forward
- The plan and 3D elevation of an earth retaining structure used for support excavation is shown in Figs. 3 and 4 respectively. The retaining structure is made of wood planks supported in the horizontal direction on vertical steel piles (HP sections). The HP piles shape of an H and are typically used for piles. The section properties of these sections (A, I, S, etc…) are given in Part 1 of the AISC steel manual. The spacing of the supporting HP piles is 20ft. The height of the piles is 15 from top of the pile to top of the footing. The height of the water table from the top of the footing is 9 ft as shown in the elevation in Fig. 4. The pile height and soil properties and the earth pressure distribution behind the retaining structure are shown in Fig. 5. Figs. 6 shows the equations for earth pressure. q is a live load surcharge that accounts for traffic on top of the embankment; q is typically assumed to be 250 psf (per the bridge code (AASHTO)). Use Fy = 50 ksi 1. Determine…arrow_forwardfind SFD and BMD? where at node K the load is 25 kiparrow_forwardfind SFD and BMDarrow_forward
- Engineering Fundamentals: An Introduction to Engi...Civil EngineeringISBN:9781305084766Author:Saeed MoaveniPublisher:Cengage LearningResidential Construction Academy: House Wiring (M...Civil EngineeringISBN:9781285852225Author:Gregory W FletcherPublisher:Cengage LearningFundamentals Of Construction EstimatingCivil EngineeringISBN:9781337399395Author:Pratt, David J.Publisher:Cengage,