(Solution) 1330143 1525370 1312257 1494717 1385822 1557598 1469066 1547011 1565671 1124576 1773806 1652490 1744558 1678286 1636597 1738847 1576383 1846508 | Snapessays.com


(Solution) 1330143 1525370 1312257 1494717 1385822 1557598 1469066 1547011 1565671 1124576 1773806 1652490 1744558 1678286 1636597 1738847 1576383 1846508


Instructions: Read this very carefully. In one Excel file create two sheets. Label one sheet “Problem1” and label the second sheet “Problem 2.” Your solutions to the two problems should berecorded on the corresponding sheet. Additionally, you should clearly label each part of the problemswith (a), (b), etc., and every computation should be labeled. For example, in the cell next tothe mean of the data, you should have typed the word mean or average.Be sure to do your computations using Excel. Do not do computations using Table A or on acalculator and then type the answers into Excel.1. Cheap-As-Dirt Rental Company advertises that the average cost of a rental they find forundergraduate students at the University of Oregon is $540 with a standard deviation of$75 (Let us assume the rents are approximately Normally distributed.) The Department ofConsumer Protection will investigate the company if, when they choose a sample of students,they find that the average rental cost for those students is $610 or more.(a) (4 points) Assuming that the company is advertising truthfully, what is the probability that the company will be investigated if the Department of Consumer Protection only samples one client?(b) (4 points) Assuming that the company is advertising truthfully, what is the probability that the company will be investigated if the Department of Consumer Protection samples 10 clients?(c) (4 points) Assuming that the company is advertising truthfully, what is the probability that the company will be investigated if the Department of Consumer Protection samples 50 clients?2. In New York City in the late 1970s and early 1980s, parking meter collections averaged $1.75million per month with a standard deviation of $302 thousand per month. Assume thatthe amount generated per month is Normal with the mean and standard deviation from theprevious sentence.For about two years the city hired Brink’s Inc. to do collections instead. The data file givesthe collections that Brink’s reported to the city during that period.(a) (2 points) What is the sample size for this data?(b) (4 points) What is the sample mean?(c) (6 points) The city was concerned that Brink’s was stealing money from the parkingmeter receipts. Assume that this sample of months is like a random sample. Given youranswers to the first two parts, what is the probability of a sample at least as far belowthe mean as the sample from the period of the Brink’s contract?1330143

 

1525370

 

1312257

 

1494717

 

1385822

 

1557598

 

1469066

 

1547011

 

1565671

 

1124576

 

1773806

 

1652490

 

1744558

 

1678286

 

1636597

 

1738847

 

1576383

 

1846508

 

1746899

 

1685611

 

1794467

 

1695017

 

1671626

 

1566107

 


Solution details:
STATUS
Answered
QUALITY
Approved
ANSWER RATING

This question was answered on: May 23, 2022

Solution~00021147602365.zip (25.37 KB)


This attachment is locked

Our expert Writers have done this assignment before, you can reorder for a fresh, original and plagiarism-free copy and it will be redone much faster (Deadline assured. Flexible pricing. TurnItIn Report provided)

Pay using PayPal (No PayPal account Required) or your credit card . All your purchases are securely protected by .
SiteLock

About this Question

STATUS

Answered

QUALITY

Approved

DATE ANSWERED

May 23, 2022

EXPERT

Tutor

ANSWER RATING

GET INSTANT HELP

We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.

You can also use these solutions:

  • ■ As a reference for in-depth understanding of the subject.
  • ■ As a source of ideas / reasoning for your own research (if properly referenced)
  • ■ For editing and paraphrasing.

This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student.

Get Free Price Quote