How do I input formulas in the excel spreadsheet using hypothetical numbers?

Anonymous
timer Asked: Oct 5th, 2018
account_balance_wallet $15

Question Description

I have a project due tomorrow midnight that is an excel spreadsheet. There are already values in the sheet but it has to be finished with hypothetical numbers ad formulas in each cell.

Unformatted Attachment Preview

Quantitative Reasoning Project 1: Gradebook Due Date: October 6, 2018 In this project, you will create a spreadsheet to calculate your grade for the QR course. The gradebook should give you a running tally of your grade at this point in the course, which requires that you use weighted averages. 1. (30%) You spreadsheet must contain a section for: 24 homework/excel files (0-10 pts each) 2 projects (100 pts each) 1 midterm (100 pts each) 1 final (100 pts each) An area to enter the weights ( 35%, 15% ETC) for each of the categories Your spreadsheet must be well labeled and neat. 2. (10%) Create cells which will compute the average HW grade, average project grade, and average exam grade. Name these cells appropriately, so if used in a formula the name will appear not the cell reference. 3. (10%) Create cells which will compute the max and min grades for the HW and Excel grades 4. (20%) Create a Histogram of your HW/Excel grades. You must choose appropriate bin sizes so that there is more than one column in your chart. Keep the chart next to where you enter grades, not on a separate sheet, so when you enter your grades the columns will change. 5. (5%) Format all of this nicely with borders and shading. Try to arrange so that it all fits onto one screen when Excel is opened to the max width of the monitor screen. 6. (20%) Create a cell which computes your total grade using the ideas of weighted average as discussed in class. 7. (5%) Calculate your average with a 100 for the projects and exams. What is your average if you get 100 on the projects and exams? Enter a grade of zero for the projects. What is your average if you do not complete the projects? Answer these two questions on the spreadsheet. A B 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 HW Number 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 HW 28 Average 29 HW Max 30 HW Min HW Grade 40% 5 7 10 5 6 6.2 7.8 4 10 5 6.6 10 4 C D My Grade Spreadsheet Project Project Number Grade 1 2 Project Average Project Max Project Min 30% 100 50 75 100 50 E F G H Final Exam Number Exam Grade Midterm Exam Midterm Exam 1 15% 100 1 15% 100 Final Exam Average Exam Max Exam Min 100 100 100 Midterm Exam Average Max Min 100 100 100 A 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 B C D E F G Overall Average 63.9 Enter a grade of zero for the projects. What is your average is you do not complete the projects? If you do not complete the projects and you get a 0 your average is 58.8 What is your average if you get 100 on the projects and exams? Answer this question in this box. If you get 100 on both projects and the exams you will get a 99.1 H A 64 B C D E F G H ...
Purchase answer to see full attachment

Tutor Answer

Jpmwriters
School: New York University

...

flag Report DMCA
Review

Anonymous
awesome work thanks

Similar Questions
Related Tags

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors