Recall the car data set you identified in Week 2. You will want to calculate th

Recall the car data set you identified in Week 2. You will want to calculate the average for your data set. (Be sure you use the numbers without the supercar outlier) Once you have the average count how many of your data points fall below the average. You will take that number and divide it by 10. This will be your p or “success” in your problem. Once you have p, calculate q.
If you were to find another random sample of 10 cars based on the same data, what is the probability that exactly 4 of them will fall below the average? Make sure you interpret your results.
If you were to find another random sample of 10 cars based on the same data, what is the probability that fewer than 5 of them will fall below the average? Make sure you interpret your results.
If you were to find another random sample of 10 cars based on the same data, what is the probability that more than 6 of them will fall below the average? Make sure you interpret your results.
If you were to find another random sample of 10 cars based on the same data, what is the probability that at least 4 of them will fall below the average? Make sure you interpret your results.

Instructions 1. Download this Excel file and rename it as FirstName_LastNa

Instructions
1. Download this Excel file and rename it as FirstName_LastName_DDMMYYYY.
Click “Enable Editing” and do computations. When done, upload your file for grading.
2. Compute the required statistics using the provided formulas. Keep four decimal places.
You can copy and paste these formulas but don’t forget to remove the invisible now quotation mark at the beginning.
3. Draw the boxplots for each kind of water. Show title, median,Q1,Q3, minimum, and maximum on the chart.
4. Give a brief comment on:
a. What the pH indicator is.
b. Why it is important.
c. Which kind of water has higher value of pH.
d. Which kind of water has greater variability of the pH. (Hint: Use the interquartile range IQR)

A 20 page Credit but it isn’t actually 20 pages because the first 5 pages are un

A 20 page Credit but it isn’t actually 20 pages because the first 5 pages are unnecessary & half of the credit is just you reading it & doing the homework/performance task(s) also. Do not Leave Anything Blank. Answer everything. You can use Google Docs or whatever it tells you to use for the Performance Task(s).
Important Info

The order was placed through a short procedure (customer skipped some order details).
Please clarify some paper details before starting to work on the order.

Type of paper and subject
Number of sources and formatting style
Type of service (writing, rewriting, etc)

Use excel existing features to run numbers based on what the assignment asks. I

Use excel existing features to run numbers based on what the assignment asks. I will attach 2 excel files and 1 word document. the word document has the directions for the writer to follow. In the writers notes please jot down the steps/buttons in excel they used to complete assignment.

For this final assignment, you will combine all of the knowledge you have gained

For this final assignment, you will combine all of the knowledge you have gained throughout this course to complete the final course project/mock study. When you complete this assignment, you will have completed a small mock study that mirrors the process of completing a larger study for your dissertation or a peer-reviewed publication. Use wk1-wk7 worksheets as references to complete week 8 worksheet. ONLY COMPLETE WK 8 WORKSHEET BASED AND PULL DATA FROM PREVIOUS WORKSHEETS

Online statistics class using Hawkes learning. I need the whole class done.

Online statistics class using Hawkes learning. I need the whole class done.
Important Info

The order was placed through a short procedure (customer skipped some order details).
Please clarify some paper details before starting to work on the order.

Type of paper and subject
Number of sources and formatting style
Type of service (writing, rewriting, etc)

Instructions will be uploaded later. Important Info

Instructions will be uploaded later.
Important Info

The order was placed through a short procedure (customer skipped some order details).
Please clarify some paper details before starting to work on the order.

Type of paper and subject
Number of sources and formatting style
Type of service (writing, rewriting, etc)

This is your opportunity to show that you have mastered the Excel skills in this

This is your opportunity to show that you have mastered the Excel skills in this course, and create charts and tables to support your Topic Proposal. You do not have to update your Word report at this time, you only need to create the tables/charts that you will use in the final version of the report. You will be graded only on your Excel work, using the Skill list below, which are mapped to the grading rubrics for this assignment.

This is your opportunity to show that you have mastered the Excel skills in this

This is your opportunity to show that you have mastered the Excel skills in this course, and create charts and tables to support your Topic Proposal. You do not have to update your Word report at this time, you only need to create the tables/charts that you will use in the final version of the report. You will be graded only on your Excel work, using the Skill list below, which are mapped to the grading rubrics for this assignment.