Category: Mathematics Homework Help

This second assignment will have you building on your understanding of and ability to use the basic elements of Excel that you have been exploring in the readings and tutorials in Weeks 1-5. We start with a same data file used in Project #1 but incorporate additional functions of Excel in the analysis of the data.

The first file contains the instructions for completing the project. The second file contains that data that you must use to complete the project.

Choose a real number A where 30 < A < 180.
In your own words, determine the six trigonometric function values (exact values) for A using the coordinates of the point on the unit circle determined by that real number.
Describe how these values are calculated

The requirements will be attached in the attachment. I hope to reduce the check rate and write carefully in accordance with the requirements and format. I hope to get a better score because this is the final assignment.

My Hw is about Random sampling and representing data by graphs. 1) Bar graph 2) circle graph 3) pictograph for categorical data. 1)Line plot 2) stem-and-leaf plot 3) histogram for Measurement data. Do only these questions : (29.3): 1, 2, 3, 6 (30.1): 3, 4, 6, 7, 8 generate graphs using technology. Do not do it by hand. It is easier. I upload our materials about the types of graphs. They may help.

Create a Presentation on a study about female/male weight and age

Must be good at creating a powerpoint presentation with graphs and tables

In-dept info attached.

There are selected questions that I need assistance with. Here are the select questions that have been given

Complete 1.6: 3, 5, 15, 21 – 29 (odd), 35, 37, 43, 49 a) only, 53 – 59 (odd), 60, 62

Complete 1.7: 1 – 23 (odd), 33, 35, 37, 41, 59, 60, 61, 66

Complete 1.8: 1 – 19 (odd), 23, 25, 27, 35, 37, 39, 44, 47, 49

Questions are from textbook: Calculus And Its Applications, Second Edition,by Bittinger, Ellenbogen, and Surgent (ISBN: 00135931045 or 9780135931042).

The questions have to be answered with at least some work shown on a separate paper in which can be put into a single pdf to be submitted

Recall the car data set you identified in Week 2. We know that this data set is normally distributed using the mean and SD you calculated. (Be sure you use the numbers without the supercar outlier)

For the next 4 cars that are sampled, what is the probability that the price will be less than $500 dollars below the mean? Make sure you interpret your results.

Please note: we are given a new sample size, we will need to calculate a new SD. Then, to find the value that is $500 below the mean you will need to take the mean and subtract $500 from it. For example, if the mean is $15,000 then $500 below this would be $14,500. Thus the probability you would want to find is P(x < 14,500).

For the next 4 cars that are sampled, what is the probability that the price will be higher than$1000 dollars above the mean? Make sure you interpret your results. Use the same logic as above. If your mean is $15,000 then $1,000 above is 15,000 + 1,000 = $16,000. Thus the probability you would want to find is P(x > 16,000).

For the next 4 cars that are sampled, what is the probability that the price will be equal to the mean? Make sure you interpret your results. Use the same logic as above.

For the next 4 cars that are sampled, what is the probability that the price will be $1500 withinthe mean? Make sure you interpret your results. Use the same logic as above.

I encourage you to review the Week 4 normal probabilities PDF at the bottom of the discussion. This will give you a step by step example to follow and show you how to find probabilities using Excel. I also encourage you to review the Week 4 Empirical Rule PDF. This will give you a better understanding on how to utilize the empirical rule.

I need an explanation for this Statistics question to help me study.

Call International oversees the quality of 200 call centers throughout the world. They want to determine how the centers compare among four variables for the most recent year:

Shift A Average Call Time (in minutes)
Shift B Average Call Time (in minutes)
Average Customer Satisfaction Level (on a 4-point scale: 1=poor, 2=average, 3=good, 4=excellent)
Average Number of Employees

Data collected for the sample of 200 Call Centers are contained in the file named Call Centers. Be sure to use all 200 data points.

Managerial Report

Prepare a report (see below) using the numerical methods of descriptive statistics presented in this module to learn how the variables contribute to the success of a call center. Be sure to include the following three items in your report.

1. Calculate descriptive sample statistics (mean, median, range, the two quartiles Q1 and Q3 (using QUARTILE.EXC), minimum, maximum, interquartile range, sample standard deviation, and coefficient of variation) for each of the four variables, along with an explanation of what the descriptive statistics tell us about the call centers.

• In this case, which measure of central tendency would be best for this application? Explain why.
• Which measure of variation would be best for this application? Explain why.
• How can one use the above descriptive statistics to understand the call centers better?
• Which graphical displays of data would you use to help understand or complement the above descriptive statistics? Explain how and why.

Note: QUARTILE.EXC works only for Excel 2010 or newer.

1. Use the z-score to determine which call centers, if any, should be considered outliers in each of the four variables.

• If there are any outliers in any category, please list them and state for which category they are an outlier.
• How would identifying outliers be useful in this application?
• What advice might you give to call centers that are outliers?
• How else would you determine outliers?

1. Compute the sample correlation coefficient, showing the relationship between Satisfaction Level and each of the other three variables (Shift A Average Call time, Shift B Average Call Time, Average Number of Employees).

• Explain what the correlation coefficients tell us about the three pairs of relationships. Use tables, charts, or graphs to support your conclusions.