Question: Confused on steps 10 and 11 10. Create a new set of data that shows the percentage of the population served that was sold a

Confused on steps 10 and 11

data that shows the percentage of the population served that was sold

a car by each dealership for each time period (see population data

to the right assume the population did not change from 2017-2019). You

will need to perform this calculation and add it to the existing

10. Create a new set of data that shows the percentage of the population served that was sold a car by each dealership for each time period (see population data to the right assume the population did not change from 2017-2019). You will need to perform this calculation and add it to the existing data. Move the new set of data to the designated place in the Charts sheet. 11. Using the data with the population figures, create a chart that makes it easy to see car sales of the top three and bottom three (based on average percentage of populations that was Top 3& Bottom 3 Dealerships by sold a car) dealerships by time period. Population Proportion Car Sales by Dealership Population Data \begin{tabular}{|c|c|c|c|c|c|c|} \hline ERCE & ROSEDALE & SEALY & SOUTHLAKE & WESTLAKE & WLDLAND & REGIONAL AVG \\ \hline 35 & 65 & 93 & 72 & . 83 & 83 & 74 \\ \hline 32 & 55 & 89 & 64 & 73 & 79 & 69 \\ \hline 32 & 59 & 79 & 58 & 73 & 81 & 69 \\ \hline 49 & 53 & 82 & 77 & 85 & 75 & 73 \\ \hline 49 & 59 & 94 & 87 & 87 & 79 & 78 \\ \hline 42 & 52 & 83 & 70 & 54 & 72 & 67 \\ \hline 23 & 41 & 84 & 66 & 59 & 51 & 61 \\ \hline 48 & 37 & 81 & 59 & 64 & 46 & 63 \\ \hline 38 & 63 & 89 & 66 & 59 & 66 & 71 \\ \hline 24 & 49 & 70 & 65 & 68 & 57 & 68 \\ \hline 26 & 52 & 66 & 55 & 51 & 69 & 61 \\ \hline 36 & 53 & 83 & 67 & 69 & 69 & \\ \hline \end{tabular} Tell me Wrap Text Merge 8 Center General $%,$00ConditionalFormatCellFormattingasTableStyles Styles 10. Create a new set of data that shows the percentage of the population served that was sold a car by each dealership for each time period (see population data to the right assume the population did not change from 2017-2019). You will need to perform this calculation and add it to the existing data. Move the new set of data to the designated place in the Charts sheet. 11. Using the data with the population figures, create a chart that makes it easy to see car sales of the top three and bottom three (based on average percentage of populations that was Top 3& Bottom 3 Dealerships by sold a car) dealerships by time period. Population Proportion Car Sales by Dealership Population Data \begin{tabular}{|c|c|c|c|c|c|c|} \hline ERCE & ROSEDALE & SEALY & SOUTHLAKE & WESTLAKE & WLDLAND & REGIONAL AVG \\ \hline 35 & 65 & 93 & 72 & . 83 & 83 & 74 \\ \hline 32 & 55 & 89 & 64 & 73 & 79 & 69 \\ \hline 32 & 59 & 79 & 58 & 73 & 81 & 69 \\ \hline 49 & 53 & 82 & 77 & 85 & 75 & 73 \\ \hline 49 & 59 & 94 & 87 & 87 & 79 & 78 \\ \hline 42 & 52 & 83 & 70 & 54 & 72 & 67 \\ \hline 23 & 41 & 84 & 66 & 59 & 51 & 61 \\ \hline 48 & 37 & 81 & 59 & 64 & 46 & 63 \\ \hline 38 & 63 & 89 & 66 & 59 & 66 & 71 \\ \hline 24 & 49 & 70 & 65 & 68 & 57 & 68 \\ \hline 26 & 52 & 66 & 55 & 51 & 69 & 61 \\ \hline 36 & 53 & 83 & 67 & 69 & 69 & \\ \hline \end{tabular} Tell me Wrap Text Merge 8 Center General $%,$00ConditionalFormatCellFormattingasTableStyles Styles

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

You are in charge of the audit of Hipp Supply Company for the year ended December 31. In prior years, your firm observed the inventory and tested compilation and pricing. Various misstatements were...

8. Create a chart that makes it easy to compare the average (2017-2019) car sales by dealership. You may need to Car Sales by Dealership add a row to the data. 10. Create a new set of data that shows...

You will have to make a physics report. Your work will require to include all these following items: GOALS (briefly but precisely state the goals of the experiemnt) THEORY (formulas, derivations,...

You will have to make a physics report. Your work will require to include all these following items: 2. GOALS (briefly but precisely state the goals of the experiemnt) 3. THEORY (formulas,...

Questions are as follows. Case is attached below Detailed steps you will take to achieve your discount, normal, or luxury strategy (examples are as follows) ? Business Model: How will you generate...

Describing Data Once we have collected data from surveys or experiments, we need to summarize and present the data in a way that will be meaningful to the reader. We will begin with graphical...

Prepare a summary of the auto industry by reviewing the attached report. Then compare these two companies, Group 1 Auto and Sonic Automotive. Base on a review of the two companies financial...

Lecture Notes DL MGT 5100 - Distribution Management Spring 2017 1.0. Day one, Monday, Monday, 9 Jan 17 1.1. Reading Assignments: Chapters 1 and 2 1.1.1. I intend to follow the book so as to provide a...

Chart Assignment: After reviewing Ch. 10 of aplia in the text, you will put your knowledge to work. You will be constructing charts based on the information below. You must use the information found...

Grebe Inc. had the following as at December 31, 2020: Cash balances in the cash registers at its retail outlets Accounts receivable (net of doubtful accounts) Petty cash balances in head office...

Suppose Radio Shack incurred the following costs at its Atlanta, Georgia, store: Newspaper advertisements........................................................................... $ 5,100 Payment to...

What is the descriptor for forms of social entrepreneurship that do not fit into the four - party typology? a ) Tybrid b ) emergent c ) nontraditional d ) nonconforming

1.Describe in a general way equilibrium equations to find reactions in supports. Denote neccessary intervals by corresponding characters. M 2M

Problem 1: idealised Lenoir heat engine cycle [15 marks] (a) Please explain what "adiabatic process", "isochoric process" and "isobaric process" are. (b) In an idealised version of the Lenoir heat...

Use function to write a program that prints all prime numbers in a range of a user input numbers. a. Draw a flow chart for the function IsaPrimenumber b. Draw a flow chart for the whole scenario c....

Plot the graph each of the polar equations given below and find an interval for 0 over which each graph is traced only once. a) r= 3-4 cos e b)r= 2+ sin e c) r= 3 cos (3 e12) d) r= 5 sin 2 0

1. 75% of the passengers buy in-flight meal in a flight from Hong Kong to Singapore. The flight is full and there are twelve passengers. What is the probability that (a) (i) eight passengers in a...

Which one of the following is not true about management in a global context? Question 4 options: The global market context requires adaptation to diverse work relationships and collaborative...

Why has government been interested in providing financial security to workers through laws? What areas do you think are likely to receive government attention in the future to ensure employee...

What are some suggestions you would have for Sara on how to save money on the benefit package? In addition to reducing benefit coverage or increasing employee deductibles across all staff, what other...

What steps will Sara need to take to conduct a benefit audit?