09 Jun Question Question 1 Create a spreadsheet that auto
Question
Question 1
Create a spreadsheet that automatically calculates your grade in this class as you enter the grades that you receive. It should include: 1) the weights of each graded assignment, 2) your grade in each assignment, and 3) your final grade. Be sure to label everything: such as the places where the information, is stored; the names of each assignment; and where to add the actual grades that you receive. Make this sheet user friendly; especially for users that see the sheet for the first time.
To use this for your benefit, you may want to design it so that it can be used to calculate your interim grade before you have all the grades. After this week, you will receive the solution from your professor and you will be able to use your solution or our solution for future classes.
Question 2
Here is sample data showing the length of nails in boxes labled 1 1/4 inch. The data is in inches.
For the following questions, you must use Excel formulas in the cells so that Excel calculates the answers for you.
1) Compute the mean:
Compute the median
Find the mode
2) Compute the first quartile; use =QUARTILE.EXC()
First Quartile
Compute the third quartile; use =QUARTILE.EXC()
Third Quartile
3) Compute the interquartile range
4) Find the largest number
Find the smallest number
What is the range?
5) What is the Variance? Use =VAR.S()
What is the standard deviation? Use =STDEV.S()
6) What is the Coefficient of Variation, or the CV?
https://www.statisticshowto.datasciencecentral.com/probability-and-statistics/how-to-find-a-coefficient-of-variation/
7) When is the Coefficient of Variation especially useful?
Copy all of the data into a column, use Column M and go from cell M1:M80
8) Use the Data Analysis tool on the numbers just copied to find the Descriptive Statistics: Click on Data Analysis and Choose Descriptive Statistics
Click on the Summary Statistics box.
Highlight the mean, median, mode, Standard deviation, Range, Minimum, and Maximum
Notice that the Data Analysis tool gives you all of the info needed for this problem except for the quartiles, variance, and CV
9) Interpret the measures of central tendency within the context of this problem.
Should the company producing the nails be concerned about the central tendency?
10) Interpret the measures of variation within the context of this problem.
Should the company producing the nails be concerned about variation?
Question 3
11) Using the data on the Pivot Table Data Sheet, create a Pivot table showing
The Type of Movie and the Domestic Gross of each Type; columns D and I on the Pivot Table Data Sheet
Have three columns: Type, Count of Type, and Sum of Total Domestic Gross
Format the Domestic Gross Field using
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Writedemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.