. In-Class Excel Assignment Due October 30, 2017 CE 101 -Fall 2017 Instructor: G
ID: 2935815 • Letter: #
Question
. In-Class Excel Assignment Due October 30, 2017 CE 101 -Fall 2017 Instructor: Grace Rushing (gemcmahe@olemiss.edu) TA: Michelle Dove (mmdove@go.olemiss.edu) *NOTE: There will be a separate Excel Assignment that should be completed outside of class in addition to this in-class assignment. . Duplicate the following: Time 1(days) 0 163 924 09 -21.60 19 -219 66.1 3.4-21.2 2 -20.5 72 Chart 1 Chart 2 Chart 3 10 12 -15 -15 15 Pumping Time 14C (MC) a. Label the worksheet "Graphs." 2. Start a new sheet called "Solving." a. File OptionsAdd-ins Manage Add-ins Solver Add-in and Analysis Toolpak b. Create two column headings titled "X" and "Y" c. In the “X" column, enter the following numbers: 0, 1, 5, 10, 100,-2 d. In the“Y, column, apply the following formula: y=1+m20 e. Use the solver function to find the value of x necessary to get a y value of 50 and 20 4 x2-20 r+1 3. Start a new sheet called Statistics. a. Enter the following numbers in a column: 52, 12,-6, 45, 8, 96, 3 b. Using the built-in Excel formulas, find the following values: i. Maximum ii. Minimum iii. Sum iv. AverageExplanation / Answer
3. Enter the data in a column A1:A7.
b. i)Type "=max(A1:A7)" for maximum value.
We get 96.
ii) Type "=min(A1:A7)" for minimum value.
We get -6.
iii)Type "=sum(A1:A7)" for the sum of the values.
We get 210.
iv) Type "=Average(A1:A7)" for average of the values.
We get 30.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.