Concept explainers
(a)
Using the Excel Help menu, demonstrate the proper use of given function TRUNC(number, num_digits) with a simple example.
(a)
![Check Mark](/static/check-mark.png)
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)
![Check Mark](/static/check-mark.png)
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)
![Check Mark](/static/check-mark.png)
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)
![Check Mark](/static/check-mark.png)
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)
![Check Mark](/static/check-mark.png)
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)
![Check Mark](/static/check-mark.png)
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
- a. Determine the effective area for the case shown in the figure below. Suppose that l = 4 in. For L5 x 5 x 5/8: Ay = 5.90 in.², = 1.47 in. L5 × 5 × 58 Weld (Express your answer to three significant figures.) A₂ = 6.25 in.2 b. Determine the effective area for the case shown in the figure below. Suppose that = 4 in. PL38 x 4 Weld (Express your answer to three significant figures.) A₁ = in.2 c. Determine the effective area for the case shown in the figure below. PL³/8 x 5 Weld (Express your answer to three significant figures.) in, 2 A₁ = d. Determine the effective area for the case shown in the figure below. PL/2 × 51/2 оо 3/4-in.-diam. bolts (Express your answer to three significant figures.) A₂ = in.2 e. Determine the effective area for the case shown in figure below. PL³½ x 6 7/8-in.-diam. bolts (Express your answer to three significant figures.) Ae in.2arrow_forwardAn American Standard Channel shape must resist a factored tensile load. The length is 15 ft, and there will be two lines of 7/8-in. diameter bolts in the web, as shown in the figure below. Estimate the shear lag factor U to be 0.85. (In a practical design, once the member and bolt layout are selected, the value of U could be computed and the member design could be revised if necessary.) Use A36 steel. For the steel Fy = 36 ksi and F₁ = 58 ksi. Try the tension members given in the table below. Tension member A, (in.²) tw (in.) ry (in.) C10 x 20 5.87 0.379 0.690 C3 × 6 1.76 0.356 0.413 C6 × 8.2 2.39 0.200 0.536 C5 × 9 2.64 0.325 0.486 Bolt lines Select an American Standard Channel shape to resist a factored tensile load of 120 kips. A) C10 × 20 B) C3 × 6 C) C6 x 8.2 D) C5 x 9 -Select- V What is the required gross area? (Express your answer to three significant figures.) Ag = in.2 What is the required effective area? (Express your answer to three significant figures.) Ae = in.2 What is…arrow_forwardIt proposed to provide pile foundation for a heavy column; the pile group consisting of 4 piles, placed at 2.0 m centre to centre, forming a square pattern. The under-ground soil is clay, having Cu at surface as 60 kN/m², and at depth 10 m, as 100 kN/m². Compute the allowable column load on the pile cap with factor of safety of 3.0, if the piles are circular having diameters 0.5 m each and length as 10 m.arrow_forward
- A 12 m long and 300 mm diameter concrete pile is driven in a uniform deposit of sand (p = 36°). The water table is very much down and is not likely to rise in future. The average dry unit weight of sand is 18 kN/m². Calculate the safe load capacity of the pile with factor of safety of 2.5. (use K-1.5 and 8=0.75 q). If the allowable load is increased by 20% what will be the length of the pile.arrow_forwardQ9;Find the invert level for each pipe and the manhole type From to Dmm Lm S Invert Invert in out MH1 MH2 250 110 0.003 MH2 MH3 250 120 0.003 MH3 MH4 250 125 0.003 MH5 MH6 250 80 0.003 MH6 MH4 250 100 0.003 MH4 MH7 300 120 0.0025 GL MH MH depth type 888888arrow_forwardQ8; Check the sewer pipe size sewer lines From to 9 D S V full Q full q/Q d/D (x103) mm m/sec m3/sec full m3/sec MH1 MH2 1.38 250 0.003 MH2 MH3 2.77 250 0.003 MH3 MH4 4.3 250- 0.003 MH5 MH6 0.41 250 0.003 MH6 MH4 4.81 250 0.003 MH4 MH7 9.81 250 0.003arrow_forward
- An engineer is designing a fountain, as shown, and will install a nozzle that can produce a vertical jet. How high (h) will the water in the fountain rise if Vn=26 m/s at h=0?arrow_forwardQ1 A city has a population of 100000. In this city, there are; • 5schools, each of 400 student capacity. • 2hotel of 300 guest capacity. • One hospital of 500 bed capacity in which the number of employees is 200. •Theatre 400 seat Estimate the average, maximum, peak and minimum sanitary sewage flowrates of the city. Type of establishment Unit Typical Iter/day/unit Shopping center Airports m² 4 Passenger 15 Theatre Seat 10 Office Person 50 School Student 60 Hotel Guest 190 Bed 1000 Hospital Employee 40 4.5 4 3.5 3 1 10 100 1000 Population in thosandarrow_forwardThe storm sewer system shown below receives storm water from five subareas (A, B, C, D, E,F and G). For each subarea; the drainage area, the longest flow path length, the slope of ground surface and runoff coefficient are as given in Table I. Estimate storm water flowrate received by each of the four inlets. Assume the area is dense residential area. The diameters and lengths of sewer given in table Sewer line Diameter Length (m) From To (mm) I1 13 300 136 12 13 300 110 13 14 400 120 zone Area (m²) L Slope Runoff (m) of ground surface coefficient A 8000 75.8 0.01 0.8 B 12000 127.3 0.0081 0.7 C 12000 121.2 0.012 0.4 D 20000 194 0.01 0.6 E 20000 200 0.01 0.6 F 22000 220 0.01 0.6 G 21000 215 0.01 0.6 B A E w 12 13 F 14 Plan layoutarrow_forward
- 11.6 The motion of a particle is defined by the relation x = 2t3 - 15t² + 24t4, where x is expressed in meters and t in seconds. Deter- mine (a) when the velocity is zero, (b) the position and the total distance traveled when the acceleration is zero.arrow_forwardRatio of depth to diameter d/D Q3 -A sanitary sewer is used to carry 0.12m³/sec when flowing full and conditions о 1.0 Values of fu 1.1 1.2 1.3 0.9 0.8 Manning's n 0.7 0.6 0.5 0.4 0.3 0.2 0.1 Discharge Velocity Hydraulic properties of cicular sewers 0.1 0.2 0.3 0.4 0.5 0.6 0.7 0.8 0.9 1.0 1.1 Hydraulic elements and full such as minimum flow velocity must be applied. Determine the commercial pipe size that must be used and the gradearrow_forwardFor the tower shown in Figure (2), check the suitability of the proposed piled foundation with the following infiormation: (minimum safety factor against failure is (2). (neglect the group action), (V - 2250 kN, including pile cap weight) and (M 4500 kN.m), the pile group consists of one central the distributed and eight piles circumference of a (6 m) diameter circle ( 45 ) degrees appart}. pile on = 1 m 8 m diameter cap 20 m Figure (2) 10 m M 0.5 m diameter bored pile -30 kPa. y= 19 kN/m² Gs-2,7 Sand Clayarrow_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,
![Text book image](https://www.bartleby.com/isbn_cover_images/9781305084766/9781305084766_smallCoverImage.gif)
![Text book image](https://www.bartleby.com/isbn_cover_images/9781285852225/9781285852225_smallCoverImage.gif)
![Text book image](https://www.bartleby.com/isbn_cover_images/9781337399395/9781337399395_smallCoverImage.gif)