Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Calculate Cumulative Statistics for One Condition You need to create a search by serial number and an advanced search of any criteria and return the
Calculate Cumulative Statistics for One Condition You need to create a search by serial number and an advanced search of any criteria and return the required results. e. Enter the value 24545262 in cell B2. f. Insert a function in cell D2 that will return the type of any item based on which Serial number is entered in cell B2. (10 marks) Hint: Use the "Vlookup" function. g. Insert a function in cell F2 that will return the Special Notes of any item based on which Serial number is entered in cell B2. (10 marks) h. Enter the following values for the advanced search criteria in the range K3:S3: (5 marks) - Color= White - Type = Washer - Star Alliance A+ = Yes i. Create an advanced search using the search criteria in the range K2:S3 and the inventory data (including headers) where the results will be displayed in the search results (starting in cell K10) ). (15 marks) j. Do you see results populating as expected? If not, you are not doing the advanced filter correctly. Statistical calculations: k. On the Study hour sheet, graph a scatterplot with hours of study on the " x " and grade on the " y " axis placed in range C2:H16. Make sure that the chart and x,y. axis have proper labels and titles. (10 marks) I. Graph the best fit line and obtain the mathematical function of it using the intercept and the slope functions placed in cells J2 and J3 respectively. (10 marks) m. Use the correlation function in cell J4 to calculate the correlation between hours and grades
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started