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
LMS Integrated for MindTap Engineering, 2 terms (12 months) Printed Access Card for Moavni's Engineering Fundamentals: An Introduction to Engineering, 5th
- The structures in the following problems are single-story, one-bay assemblies representing one common lateral force- resisting systems used in buildings: Moment-Resisting Frames (MRFS). Each frame is fix-connected at its base. Your tasks are as follows: 1. 2. Solve for the support reactions (vertical, lateral, and moment) under the applied lateral load. Determine member end forces (axial, shear, and moment) for all relevant structural members.arrow_forwardThe structures in the following problems are single-story, one-bay assemblies representing one common lateral force- resisting systems used in buildings: Moment-Resisting Frames (MRFs). Each frame is fix-connected at its base. Your tasks are as follows: Solve for the support reactions (vertical, lateral, and moment) under the applied lateral load. Determine member end forces (axial, shear, and moment) for all relevant structural members. 1. 2. 3. Draw internal force diagrams (bending moment) for the required elements. 4. Determine the lateral deflection of joint B Be sure to clearly label your diagrams and show all work leading to your solutions. You must use the slope deflection equations to solve the problem, otherwise it will take forever. Use dimensions referenced to elements' centerlines. You shall neglect axial and shear induced deformations.arrow_forwardWhat are some relative code requirements specific to a roof system components?arrow_forward
- The ____________ costs can often be the determining factor in a successful project. Group of answer choices Overhead Material Labor Profitarrow_forwardWho is responsible for conducting special inspections and ensuring the work completed complies with design documents and referenced standards, why are specical inspections required?arrow_forwardYou are viewing Attempt 1/Continue Work * Incorrect The 123-kg industrial door with mass center at G is being positioned for repair by insertion of the 8° wedge under corner B. Horizontal movement is prevented by the small ledge at corner A. If the coefficients of static friction at both the top and bottom wedge surfaces are 0.65, determine the force P required to lift the door at B. Assume a = 1.4 m, b = 1.2 m, a = 8° A Answer: P = 1144.28 N Barrow_forward
- How can new sustainable materials change dead load calculations in future designs in earthquake-prone areas?arrow_forwardGiven the truss with loading shown. Note that the roller connection at Joint D is in atrack so that it cannot move in the x-direction, but it can roll in the y-direction.Solve the truss with the virtual load you would use if you are going to solve for the verticaldeflection at Joint E using the method of virtual work.Note: Just solve the truss. You DO NOT need to find the vertical deflection at Joint E.arrow_forwardQuestion (1): (18 Marks) Gaza City has a total population of 650,000 inhabitant, where 75% of the population is connected to wastewater collection system. The water consumption per capita is 100 L/day. Currently, the collected flow treated partially by aerated lagoon system. The municipality intend to change the treatment system to a completely mixed activated sludge system to be used for organic matter removal only to fulfill the Palestinian standards for reuse (Soluble BOD 30 mg/l). The given data from the municipality laboratory and assumptions: ⚫ The influent soluble Biological Oxygen demand = 500 mg/l. Biomass yield (Y) = 0.5 mg VSS/mg BOD removed • Endogenous decay rate constant (Ka) = 0.05d¹ • • The concentration of biomass (X) = 3000 mg MLVSS The concentration of recycled biomass (X) = 10000 mg MLVSS/L Growth rate (d) 2.5 1.25 100 For the completely mixed activated sludge system find the following: a) The average flow to the treatment plant. b) The mean cell residence time. c)…arrow_forward
- Question (3): (20 Marks) You have been assigned to design a secondary wastewater treatment component based on a tricking filter technique. The flow rate is 3500 m³/day, the raw wastewater has a BOD5 of 600 mg/l. This wastewater is primarily treated with an efficiency of 35%. • Assume suitable design criteria to obtain a BOD effluent of 15 mg/l. Design the secondary clarifier • Perform all the necessary cheeks on your design.arrow_forwardQuestion (3): (20 Marks) You have been assigned to design a secondary wastewater treatment component based on a tricking filter technique. The flow rate is 3500 m³/day, the raw wastewater has a BOD5 of 600 mg/l. This wastewater is primarily treated with an efficiency of 35%. • Assume suitable design criteria to obtain a BOD effluent of 15 mg/l. Design the secondary clarifier • Perform all the necessary cheeks on your design.arrow_forwardData:Total budget = $25,000BCWS = $ 8,333BCWP = $ 6,400ACWP = $ 7,800Project duration = 40 daysData date: 10 days Perform the following analyses of the project based on the data given above.a. Cost Variance b. Schedule Variancearrow_forward
Engineering Fundamentals: An Introduction to Engi...Civil EngineeringISBN:9781305084766Author:Saeed MoaveniPublisher:Cengage Learning
Residential Construction Academy: House Wiring (M...Civil EngineeringISBN:9781285852225Author:Gregory W FletcherPublisher:Cengage Learning
Fundamentals Of Construction EstimatingCivil EngineeringISBN:9781337399395Author:Pratt, David J.Publisher:Cengage,