Question

In: Statistics and Probability

Refer to the traffic congestion cost table as the primary source of your observations, and do...

Refer to the traffic congestion cost table as the primary source of your observations, and do the followings;

1.     Summarize the cost by calculating the mean and standard deviation for each region

2.     Calculate the Standard deviation for all five regions ONLY TYPED HARD COPY IS ACCEPTED

3.     Use a bar graph for this data set and show the five averages on the graph

4.     List all the averages and standard deviations of five regions for comparison

City Cost Traffic
Northeastern cities Baltimore, MD 530
Boston, MA 880
Hartford, CT 250
New York, NY 1,090
Philadelphia, PA 420
Pittsburgh, PA 400
Washington, DC 1,420
Midwestern cities Chicago, IL 570
Cincinnati, OH 200
Cleveland, OH 140
Columbus, OH 230
Detroit, MI 530
Indianapolis, IN 130
Kansas City, MO 160
Louisville, KY 190
Milwaukee, WI 370
Minneapolis-St. Paul, MN 270
Oklahoma City, OK 190
St. Louis, MO 540
Southern cities Atlanta, GA 640
Charlotte, NC 390
Ft. Lauderdale, FL 290
Jacksonville, FL 400
Memphis, TN 140
Miami, FL 680
Nashville, TN 340
New Orleans, LA 340
Norfolk, VA 390
Orlando, FL 420
Tampa, FL 310
Southwestern cities Albuquerque, NM 210
Austin, TX 410
Corpus Christi, TX 50
Dallas, TX 750
Denver, CO 420
El Paso, TX 120
Fort Worth, TX 420
Houston, TX 750
Phoenix, AZ 630
Salt Lake City, UT 90
San Antonio, TX 290
Western cities Honolulu, HI 470
Los Angeles, CA 980
Portland, OR 500
Sacramento, CA 280
San Bernardino-River, CA 1,320
San Diego, CA 480
San Francisco-Oakland, CA 930
San Jose, CA 960
Seattle-Everett, WA 880

Solutions

Expert Solution

1. Mean by region is equal to the total cost of traffic across all citities in the region divided by the total no of cities in that region.

e.g Like for North Eastern cities , the Total cost of traffic =(530+880+250+1090+420+400+1420)/7

=4990/7

=712.9

Assuming that the cities in each region are only cities and represent entire population

Standard Deviation= sqrt(((530-Mean)2+(880-Mean)2+(250-Mean)2+(1090-Mean)2+(420-Mean)2+(400-Mean)2+(1420-Mean)2)/7)

=sqrt(((530-712.9)2+(880-712.9)2+(250-712.9)2+(1090-712.9)2+(420-712.9)2+(400-712.9)2+(1420-712.9)2)/7)

=396.7

Regions City Cost Traffic Mean Standard Deviation
Northeastern cities Baltimore, MD 530 712.9 396.7
Boston, MA 880
Hartford, CT 250
New York, NY 1,090
Philadelphia, PA 420
Pittsburgh, PA 400
Washington, DC 1,420
Midwestern cities Chicago, IL 570 293.3 158.6
Cincinnati, OH 200
Cleveland, OH 140
Columbus, OH 230
Detroit, MI 530
Indianapolis, IN 130
Kansas City, MO 160
Louisville, KY 190
Milwaukee, WI 370
Minneapolis-St. Paul, MN 270
Oklahoma City, OK 190
St. Louis, MO 540
Southern cities Atlanta, GA 640 394.5 145.0
Charlotte, NC 390
Ft. Lauderdale, FL 290
Jacksonville, FL 400
Memphis, TN 140
Miami, FL 680
Nashville, TN 340
New Orleans, LA 340
Norfolk, VA 390
Orlando, FL 420
Tampa, FL 310
Southwestern cities Albuquerque, NM 210 376.4 252.6
Austin, TX 410
Corpus Christi, TX 50
Dallas, TX 750
Denver, CO 420
El Paso, TX 120
Fort Worth, TX 420
Houston, TX 750
Phoenix, AZ 630
Salt Lake City, UT 90
San Antonio, TX 290
Western cities Honolulu, HI 470 755.6 317.2
Los Angeles, CA 980
Portland, OR 500
Sacramento, CA 280
San Bernardino-River, CA 1,320
San Diego, CA 480
San Francisco-Oakland, CA 930
San Jose, CA 960
Seattle-Everett, WA 880

2. Standard Deviation of all 5 regions, for that we have to first find the mean of all 5 regions taken together

Mean of all 5 regions taken together= 475.8

Applying the formula above for Standard Deviation

Regions City Cost Traffic
Northeastern cities Baltimore, MD 530
Boston, MA 880
Hartford, CT 250
New York, NY 1,090
Philadelphia, PA 420
Pittsburgh, PA 400
Washington, DC 1,420
Midwestern cities Chicago, IL 570
Cincinnati, OH 200
Cleveland, OH 140
Columbus, OH 230
Detroit, MI 530
Indianapolis, IN 130
Kansas City, MO 160
Louisville, KY 190
Milwaukee, WI 370
Minneapolis-St. Paul, MN 270
Oklahoma City, OK 190
St. Louis, MO 540
Southern cities Atlanta, GA 640
Charlotte, NC 390
Ft. Lauderdale, FL 290
Jacksonville, FL 400
Memphis, TN 140
Miami, FL 680
Nashville, TN 340
New Orleans, LA 340
Norfolk, VA 390
Orlando, FL 420
Tampa, FL 310
Southwestern cities Albuquerque, NM 210
Austin, TX 410
Corpus Christi, TX 50
Dallas, TX 750
Denver, CO 420
El Paso, TX 120
Fort Worth, TX 420
Houston, TX 750
Phoenix, AZ 630
Salt Lake City, UT 90
San Antonio, TX 290
Western cities Honolulu, HI 470
Los Angeles, CA 980
Portland, OR 500
Sacramento, CA 280
San Bernardino-River, CA 1,320
San Diego, CA 480
San Francisco-Oakland, CA 930
San Jose, CA 960
Seattle-Everett, WA 880
Mean 475.8
Standard Deviation 311.7

3.

4.

Regions Mean Standard Deviation
Northeastern cities 712.9 396.7
Midwestern cities 293.3 158.6
Southern cities 394.5 145.0
Southwestern cities 376.4 252.6
Western cities 755.6 317.2

Related Solutions

Consider your observations of the halogens. Refer to the table of Standard Reduction Potentials (Links to...
Consider your observations of the halogens. Refer to the table of Standard Reduction Potentials (Links to an external site.)Links to an external site. (the table is arranged alphabetically). What can you infer about the relationship between oxidant strength and standard reduction potential? i.e. if a halogen is a strong oxidizing agent does it have a more positive or more negative standard reduction potential? With that in mind, would you expect MnO4-(aq) to react with NaI in acidic or in basic...
Consider the following data on the estimated cost (in millions of dollars) resulting from traffic congestion...
Consider the following data on the estimated cost (in millions of dollars) resulting from traffic congestion for different urban areas. The following are the data for the 13 largest U.S. urban areas. Urban Area Total Cost (millions of dollars) New York 16 Los Angeles 13 Chicago 7 Washington, D.C. 5 Houston 5 Dallas, Fort Worth 4 Detroit 4 Miami 4 Phoenix 4 Philadelphia 4 San Francisco 3 Boston 3 Atlanta 3 (a) Calculate the mean and standard deviation for this...
9-41 A do-nothing and two mutually exclusive alternatives are being considered for reducing traffic congestion. User...
9-41 A do-nothing and two mutually exclusive alternatives are being considered for reducing traffic congestion. User benefits come from reduced congestion once the project is complete, while user disbenefits are due to increased congestion during construction. The interest rate is 8%, and the life of each alternative is 15 years. Which alternative should be chosen? Alternative A B User benefits ($M/yr) 2.1 2.6 User disbenefits ($M) 1.2 2.1 First cost ($M) 6.9 9.9 (a) Use the benefit-cost ratio. (b) Use...
Refer to the ANOVA table for this regression.   Source SS d.f. MS   Regression 1,035,678    15...
Refer to the ANOVA table for this regression.   Source SS d.f. MS   Regression 1,035,678    15     69,045   Residual 1,415,013    35     40,429      Total 2,450,691    50     (a) State the degrees of freedom for the F test for overall significance.   The degrees of freedom for regression are ________ and for error ______ . (b) Use Appendix F to look up the critical value of F for α = .05. (Round your answer to 2 decimal places.)   F.05 (c-1)...
Refer to the demand and cost data for a pure monopolist given in the table.
OutputPriceTotal Cost0$300$25012752602250290322535042005005175680Refer to the demand and cost data for a pure monopolist given in the table. If the monopolist perfectly price-discriminated and sold each unit of the product at the maximum price the buyer of that unit would be willing to pay, and if the monopolist maximized profits, then the total profit received would be$675.$450.$1,125.$325.
To answer this question, refer to the following two-way ANOVA summary table: SOURCE SS df MS...
To answer this question, refer to the following two-way ANOVA summary table: SOURCE SS df MS Rows 450.5     2 Columns 116.4 1 Interaction 2.3 2 1.15 Within-cells 260.4 24 Total 829.6 29 What is the value for MS rows? What is the value for MS columns? What is the value for MS within-cells? What is Fobt for rows? What is Fobt for column? What is Fobt for interaction?
Collect at least 11 observations of quantitative data. Give the source of your data. Construct a...
Collect at least 11 observations of quantitative data. Give the source of your data. Construct a dot plot of your data. Compute the mean, median, range, and sample standard deviation. Presentation counts.
Cost Accounting Refer to the table below. Assume that the company involved now finds that the...
Cost Accounting Refer to the table below. Assume that the company involved now finds that the learning rate is 90 percent. The 90 percent learning rate coefficient is -0.152003; that is b = -0.152003 in the formula Y = aXb. Required: Using the formula, Y = aXb, compute the labor time and costs for 5, 6, and 7 units. (Round your intermediate calculations (except for coefficient) and final answers to 2 decimal places. Unit Produced (X) Labor Time Required to...
A. Please refer to the cost table above. What is the total fixed cost of producing two units of output?
Output, qTotal Cost, $015125233340448558670A. Please refer to the cost table above. What is the total fixed cost of producing two units of output?B. Please refer to the cost table above. What is the average total cost of producing four units of output?  C. Please refer to the cost table above. What is the marginal cost of producing the fourth unit of output?D. Please refer to the cost table above. Assume that the enterprise uses only labor and capital to produce output    ...
Refer to Table 13-14. What is the total cost of producing 7 units of output?
Table 13-14QuantityofOutputFixedCostVariableCostTotalCostAverageFixedCostAverageVariableCostAverageTotalCostMarginalCost1$23$332$383$604$545$806$887$1138$155Refer to Table 13-14. What is the total cost of producing 7 units of output?a.$10b.$143c.$123d.$185
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT