Urgent help with mgt excel

All work must be shown to qualify for partial credit. Also check to make sure all your work is legible and clear before submitting it. Answer 4 out of 5 questions. You should use Excel to answer most of the questions.

1. Consumer Reports posts reviews and ratings of a variety of products on its website. The following is a sample of 20 speaker systems and their ratings. The ratings are on a scale of 1 to 5, with 5 being best.

Speaker                Rating        Speaker Rating

Infinity Kappa. 6.1  4.00 ACI Sapphire III 4.67

Allison One  4.12 Bose 501 Series 2.14

Cambridge Ensemble II  3.82 DCM KY-212 4.09

Dynaudio Contour 1.3  4.00 Eosone RSF 1000 4.17

Hsu Rsch. HRSW 12V  4.56 Joseph Audio RM7 si 4.88

Legacy Audio Focus  4.32 Martin Logan Aerius 4.26

Mission 73Ii  4.33 Omni Audio SA 12.3 2.32

PSB 400i  4.50 Polk Audio RT 12 4.50

Snell Acoustics D IV  4.64 Sunfire True Subwoofer 4.17

Thiel CS 1.5  4.20 Yamaha NS- A636 2.17

Compute the mean and the median.

Compute the first and third quartiles.

Compute the standard deviation.

What are the z-scores associated with Allison One and Omni Audio?

Do the data contain any outliers? Explain.

2. A survey on British Social Attitudes asked respondents if they had ever boycotted goods for ethical reasons (Statesman, January 28, 2008). The survey found that 23% of the respondents have boycotted goods for ethical reasons.

In a sample of six British citizens, what is the probability that two have ever boycotted goods for ethical reasons?

In a sample of six British citizens, what is the probability that at least two respondents have boycotted goods for ethical reasons?

In a sample of ten British citizens, what is the probability that between 3 and 6 have boycotted goods for ethical reasons?

In a sample of ten British citizens, what is the expected number of people that have boycotted goods for ethical reasons? Also find the standard deviation.

3. The Webster National Bank is reviewing its service charges and interest-paying policies on checking accounts. The average daily balance on personal checking accounts is $550, with a standard deviation of $150. In addition, the average daily balances are normally distributed.

a) What percentage of personal checking account customers carry average daily balances in excess of $800?

b) What percentage carry average daily balances below $200?

c) What percentage carry average daily balances between $300 and $700?

d) The bank is considering paying interest to customers carrying average daily balances in excess of a certain amount. If the bank does not want to pay interest to more than 5% of the customers, what is the minimum average daily balance it should be willing to pay interest on?

4. The following 20 observations are for two quantitative variables, x and y (Data file is Scatter and presented on Classes).

a) Create a scatter chart for these 20 observations,

b) Fit a linear trend line to the 20 observations. What can you say about the relationship between the two quantitative variables?

c) Find the correlation coefficient and the covariance. Discuss their relevance to the relationship between x and y.

5.  A Daytona Beach nightclub has the following data on the age and marital status of 140 customers.

Develop a joint probability table using the data.

Use the marginal probabilities to comment on the age of customers attending the club.

Use the marginal probabilities to comment on the marital status of customers attending the club.

What is the probability of finding a customer who is single and under the age of 30?

If a customer is under 30, what is the probability that he or she is single?

Is marital status independent of age? Explain, using probabilities.

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more