onsumers reports provided overall customer satisfaction scores for AT&T, Sprint, T-Mobile, and Verizon cell phone services in major metropolitan areas throughout the United States. The rating for each service reflects the overall customer satisfaction considering variety of factors such as cost, connectivity problems, dropped calls, static interference, and customer support. A satisfaction scale from 0 to 100 was used with 0 indicating completely dissatisfied and 100 indicating completely satisfied. The ratings for the four cell phone services is 20 metropolitan areas are as shown.  Show steps in Excel please a Consider T-Mobile first. What is the median rating?     b. Develop a five-number summary for T-Mobile service.     c Are there outliers for T-Mobile? Explain

The bar chart below shows the speed (in gigaflops using a test package) of several processors. It is intended to be used to compare the overall speeds of the processors for consumers. Identify any misrepresentation issues in the graph.

There are 22 women and 6 men. If a bar graph were drawn to represent this data, and the length of the bar for women was 5 inches long, then how long should the bar for men be? Round to the nearest tenth of an inch.

One of the basketball coaches at Cypress College wanted to see if Cypress College's Strength & Exercise class was increasing the weight that a player could bench press. The basketball coach randomly selected some of his players and determined how much they could bench press before taking the class. Then after completing the class, he again determined the weight that they could now bench press. The data for these players is given in the table below. Test whether the Strength and Exercise class is increasing the amount of weight that the players can bench press at the a=0.05 level of significance. Player Player 1 Player 2 Player 3 Player 4 Pounds Lifted Before 205 241 338 368 [ Select] ANOVA 2-SampFTest 252 330 360 2-SampTTest X^2-Test 2-PropZTest T-Test [ Select ] P-Value [ Select] Conclusion

Express all answers as decimals rounded to 3 decimal places, if needed. Express percentages as decimals (instead of 25.6%, use .256) Cell phone users in Boise can choose between three carriers: Sprint, AT&T, and Verizon. Advertising by all three companies results in a continual shift of customers. Each year, Sprint loses 30% of customers to AT&T and 30% to Verizon. AT&T loses 20% to Sprint and 10% to Verizon. Verizon loses 25% to Sprint and 25% to AT&T. Currently, Sprint has 25% of the market, AT&T has 35%, and Verizon has 40%. Use the order Sprint (S), AT&T (A), Verizon (V) throughout this assignment. 1. State the probability vector: 2. Create the transition matrix, labeling rows and columns, and draw the transition diagram. Create your matrix with the rows ordered S, A, and V, and columns ordered S, A, and V. 3. Assume that for 5 years this trend continues. State the transition matrix after 5 years. 4. What is the market share for each company after 5 years? Sprint: AT&T: Verizon: 5.…

Suppose a data set ranges from a low value of 29 and a high value of 62. Calculate the class width for a frequency table with 6 classes.

City crimes records show that 20% of all crimes are violent and 80% are nonviolent. Ninety percent of violent crimes are reported versus 70% of nonviolent crimes. What is the overall reporting rate for crimes in the city?

The infamous Gillette ad has 1.55 million “dislikes” on YouTube, making it the 26th most disliked video on YouTube.  If 1% of the people who disliked the video are male former Gillette customers who will now boycott Gillette, and if Gillette razors cost $30 for a pack of 10, and if a man uses 1 Gillette razor per day, and if a year has 365 days, how much money will Gillette lose per year?

A marketing manager for a large cafeteria chain wished to investigate sales of coffee (i.e., sales is the variable she is trying to understand). Fourteen cafeterias that were similar in such respects as volume of business, type of clientele, and location were chosen for data collection. Data were collected on sales of coffee (in hundreds of gallons) and the number of coffee dispensers within the cafeteria. The results are shown below.   Sales Number of Dispensers 631.9 1 628 1 692.5 2 688.4 2 747.4 3 773.3 3 791.4 4 803.4 4 838.7 5 879.6 5 881 6 841.1 6 860.6 7 883.8 7 Create a scatter plot and then fit a quadratic model to predict sales from the number of dispensers. If we define y to be sales (in hundreds of gallons) and x to be the number of dispensers, what is the correct quadratic model?   Group of answer choices   a. y=-6.397x2+92.85x+538.06   b. y=41.67x+614.829   c. y=0.022x-12.979   d. y=3.348x10-5x2-0.0292x+6.09   e. y=623.521x0.180

Please answer this with solution