USA Annual Purchases Report 2020 Customer ID Gender Education Annual Salary City New York Annual Purchases...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
USA Annual Purchases Report 2020 Customer ID Gender Education Annual Salary City New York Annual Purchases University High School University University University University High School С11 6233 7500 Instructions: 4233 4999 6560 6750 С12 M New York 1. Format the tables as given in the picture 1 С13 F Seattle (Alignment, Shading, Borders, Wrap text, Orientation etc). Format Annual Purchases and Annual Salary to dollar curency with two decimal places. 2. Calculate the Total Annual Purchases for each City (B16:B18) 3. Calculate the Average Annual Purchases for each Education (B21:B23) 4. Calculate the total number of customers from each gender (B26:B27) 5. Calculate the total annual salary for each gender in each city (E17:F19) 6. Calculate the total annual purchases for each gender in each city (E23:F25) 6 points Insert and format the charts as given below 4 points С14 M Chicago 5001 12000 3 C15 F New York 7034 17500 C16 F Chicago 5345 13150 6 С17 F Seattle 790 3799 8 240 2150 4300 22450 232 2500 С18 F Seattle None C19 Seattle University 10 C20 F New York None 11 12 13 14 City New York Annual Salary Gender City New York Total Annual Purchases Male Female 15 Chicago Total Annual Salary 16 17 Seattle Chicago 18 Seattle 30000 20000 Population 19 13150 2245999 12000 Education Average Annual Purchases 20000 12499 10000 University High school Annual Purchas Gender City New York Female 20 IMale Male Female New York Chicago Male 40% Male Female None Seattle Female 21 60% 22 Chicago New York Chicago 12000 Seattle 23 Male Female Gender Population Seattle 12499 22450 24 20000 13150 12699 Male 25 26 Female 27 A B E USA Annual Purchases Report 2011 Customer Annula Gender City Education Annual Salary ID Purchases C11 New York University 6233 7500 C12 M 4233 4999 New York High School Seattle Chicago University New York University Chicago University Seattle Seattle Seattle New York None C13 F University 6560 6750 C14 5001 12000 C15 F 7034 17500 5345 790 240 4300 232 C16 13150 High School None University C17 F 3799 C18 F 2150 C19 M 22450 C20 f 2500 Total Annual Annual Salary Gender City Purchases City New York New York Male Female Chicago Seattle Chicago Seattle Average Education Annual Purchases Annual Gender Purchases University High school Female City New York Chicago Seattle Male None Gender Population Male Female USA Annual Purchases Report 2020 Customer ID Gender Education Annual Salary City New York Annual Purchases University High School University University University University High School С11 6233 7500 Instructions: 4233 4999 6560 6750 С12 M New York 1. Format the tables as given in the picture 1 С13 F Seattle (Alignment, Shading, Borders, Wrap text, Orientation etc). Format Annual Purchases and Annual Salary to dollar curency with two decimal places. 2. Calculate the Total Annual Purchases for each City (B16:B18) 3. Calculate the Average Annual Purchases for each Education (B21:B23) 4. Calculate the total number of customers from each gender (B26:B27) 5. Calculate the total annual salary for each gender in each city (E17:F19) 6. Calculate the total annual purchases for each gender in each city (E23:F25) 6 points Insert and format the charts as given below 4 points С14 M Chicago 5001 12000 3 C15 F New York 7034 17500 C16 F Chicago 5345 13150 6 С17 F Seattle 790 3799 8 240 2150 4300 22450 232 2500 С18 F Seattle None C19 Seattle University 10 C20 F New York None 11 12 13 14 City New York Annual Salary Gender City New York Total Annual Purchases Male Female 15 Chicago Total Annual Salary 16 17 Seattle Chicago 18 Seattle 30000 20000 Population 19 13150 2245999 12000 Education Average Annual Purchases 20000 12499 10000 University High school Annual Purchas Gender City New York Female 20 IMale Male Female New York Chicago Male 40% Male Female None Seattle Female 21 60% 22 Chicago New York Chicago 12000 Seattle 23 Male Female Gender Population Seattle 12499 22450 24 20000 13150 12699 Male 25 26 Female 27 A B E USA Annual Purchases Report 2011 Customer Annula Gender City Education Annual Salary ID Purchases C11 New York University 6233 7500 C12 M 4233 4999 New York High School Seattle Chicago University New York University Chicago University Seattle Seattle Seattle New York None C13 F University 6560 6750 C14 5001 12000 C15 F 7034 17500 5345 790 240 4300 232 C16 13150 High School None University C17 F 3799 C18 F 2150 C19 M 22450 C20 f 2500 Total Annual Annual Salary Gender City Purchases City New York New York Male Female Chicago Seattle Chicago Seattle Average Education Annual Purchases Annual Gender Purchases University High school Female City New York Chicago Seattle Male None Gender Population Male Female
Expert Answer:
Answer rating: 100% (QA)
City Total Annual Purchases Annual Salary Gender Chart ... View the full answer
Related Book For
Principles of Foundation Engineering
ISBN: 9781337705028
9th edition
Authors: Braja M. Das, Nagaratnam Sivakugan
Posted Date:
Students also viewed these accounting questions

M F F F F M F F M M M F F F F F Use the given sequence to determine the values of n1 n2, the number of runs G, and the 5% cutoff values from Table A10.

A Rankine oval 2 m long and 1 m high is immersed in a stream U∞ = 10 m/s, as in Fig. P8.37. Estimate (a) the velocity at point A and (b) the location of point B where a particle approaching the...

A tank of water 1 m deep, 3 m long and 4 m wide into the paper has a closed sluice gate on the right side, as in Fig. P10.75. At t = 0 the gate is opened to a gap of 10 cm. Assuming quasisteady...

A steel spur pinion has 16 teeth cut on the 20 fulldepth system with a module of 8 mm and a face width of 90 mm. The pinion rotates at 150 rev/min and transmits 6 kW to the mating steel gear. What...

From the following information, prepare a statement of net assets for the city of Lucas as of June 30, 2019. Cash and cash equivalents, governmental activities. . . . . . . . . . . . . . . . . . . ....

Predict the Pxy behavior for a mixture of pentafluoroethane [R125] (1) + isobutane (2) at 30C using the PengRobinson equation of state. Compare the predicted values with experimental data given in...

Encouraging staff to incorporate firm values in decision processes.Imagine that you work in the Human Resources department of your company. Your CEO has asked your department to develop an ethics...

Dalton Hair Stylists's adjusted trial balance follows. Prepare Dalton's income statement for the year ended December 31, 2018. DALTON HAIR STYLISTS Adjusted Trial Balance December 31, 2018 Balance...

5. Use the strong Taylor approximation to em to degree 3 and the fact that 1 S 6"\" S 2 for 0 S a: S 0.1 to obtain a bound on the remainder at a: : 0.1. Use your bound on the remainder to prove a...

In a survey, adults were asked to answer yes or no to the question Do you regularly watch the evening TV news? Some of the results from the survey are detailed in the Venn diagram opposite. One adult...

Please answer question with all work shown. Thanks. Determine all the Asymptotes of y = 5x214 2+ 2x . You must use Math 31 (Limits) to confirm asymptotes

Create an infographic for Canadian Tire, based on industry benchmarks and its financial performance. Create an Infographic (visual representation of data) of the most important indicators of the...

What are two responsibilities of a LeanAgile Center of Excellence (LACE)? Explain

According to the article below: 2. What is the hypothesis? TranscribedText: Article Journal of Black Psychology Racial/Ethnic Identity, 2016, Vol. 42(3) 244258 @ The Author(s) 2015 Religious...

Give an example from your experience where you have seen a problem blamed on people that you felt was really a process problem. What additional issues were created as a result of this misplaced blame?

A Faith Based Perspective on Human Motivation and Leadership Styles What role does motivation play in how leaders lead in organizations? Share a brief example of where you have observed how a leader...

Useful Life Item Cost Purchase Date (in years) Salvage Value Machinery $58,000 Jan. 1, 2012 10 $0 Forklift 17,000 Jan. 1, 2019 U O Truck 23,400 Jan. 1, 2017 8 3,000

Which of the followingcarbocations is the least stable? CH3CH2 . CH3CHCH3 CH3 I . CH3C0 T CH3 IV. V. CH3 CH3CCH2 CH3

Estimate the friction angle of the soil C in Problem 2.7 (see Figure P2.7) at 80% relative density and void ratio of 0.61 using the empirical correlations given by a. Eq. (2.87) b. Eq. (2.88) Figure...

A tall cylindrical silo carrying flour is to be supported by a 1.5 m wide ring beam that can be designed as a continuous foundation. The inner and outer diameters of the ring are 10 m and 13 m,...

A 5 m deep excavation is required in a dry sand where = 17.5 kN/m 3 and ' = 32 (see Figure 18.11). Determine the actual depth to which the sheet pile has to be driven and the required section (from...

When are entries made to the Petty Cash account?

Describe the operation of a petty cash fund and its advantages. Indicate how control is maintained over petty cash transactions.

Real World Question Based on the financial statements of Maytag Corporation contained in the annual report booklet, what was the 1996 ending cash and cash equivalents balance? What percentage of...
Study smarter with the SolutionInn App