Posted:

STATISTICS 500-Create an Excel spreadsheet that can be used

1. Basic Excel Operation:Create an Excel spreadsheet that can be used to calculateyour grade in this class. The spreadsheet should include theweights of each graded assignment, your grade in eachassignment, and your final grade. To use this for yourbenefit you may want to design it so that it can be used tocalculate your interim grade before you have all the grades.Use a new sheet called "Grade Calculator" in the same Excelfile that you are submitting for this assignment.After this week you will receive the solution from yourprofessor and you will be able to use your solution or oursolution for future classes.2. Frequency DistributionAccording to Zillow.com, here is a list of the prices ofthe property sold (in thousands) in Washington, DCJune 29 – 30, 2016: 2024 – Do my homework – Help write my assignment online. Use Excel’s capability(=FREQUENCY()) to create a frequency distributionusing 5 bins.$316$265$299$469$240$575$1,015$105$320$1,250$192$721$320$700$420$440$368$918$2,950$585$428$563$451$560$956$333$536$625$562$930$1,575$406$673$780$405$444$961$570$288$475$443$675$449$1,550$945$785$913$879$4953. Histogram, bar chart, and pie chartUse the house price data and the bins data fromproblem 3 to create a histogram using the dataanalysis tool.a.Use the data from the =FREQUENCY()distribution and the bins data from problem 3to create a bar chart and, pie chart.

Order | Check Discount