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 A-10.
-
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 quasi-steady...
-
A steel spur pinion has 16 teeth cut on the 20 full-depth 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...
-
Sams Sushi serves only a fixed-price lunch. The price of $10 and the variable cost of $4 per meal remain constant regardless of volume. Sam can increase lunch volume by opening and staffing...
-
One of the main ideas of the passage is that: A. Faulkner was devoted to his southern roots. B. Authors employed revolutionary literary devices. C. Faulkner was a prominent author with strong...
-
Asia represents the universal powerhouse of production but only features partially in Inditexs approach. What made Asia the first worlds supplier of fashion products and a main sourcing spot in the...
-
In a certain chemical process three bottles of a standard fluid are emptied into a larger container. A study of the individual bottles shows that the mean value of the contents is 15 ounces and the...
-
Current Attempt in Progress The balance in Georgia Corn's accounts payable account at December 31, 2020, was 5900.000 before any necessary year-end adjustments relating to the following 1. Goods were...
-
1 What are the main components of personal financial planning? Solve What is the purpose of a financial plan? Solve Identify some common actions taken to achieve financial goals. How does a job...
-
Cotrone Beverages makes energy drinks in three flavors: Original, Strawberry, and Orange. The company is currently operating at 75 percent of capacity. Worried about the company's performance, the...
-
Leslie Sporting Goods is a locally owned store that specializes in printing team jerseys. The majority of its business comes from orders for various local teams and organizations. While Leslie's...
-
Euclid acquires a 7-year class asset on May 9, 2022, for $153,000 (the only asset acquired during the year). Euclid does not elect immediate expensing under 179. He does not claim any available...
-
Williams & Sons last year reported sales of $10 million, cost of goods sold (COGS) of $8 million, and an inventory turnover ratio of 2. The company is now adopting a new inventory system. If the new...
-
A ceramic manufacturer promised to deliver 25 crates of vases to a Japanese importer under a "CFR" INTERCOM agreement. During transit, however, a large number of vases were broken. The buyer wants to...
-
A company receives $364, of which $23 is for sales tax. The journal entry to record the sale would include a ?
-
Mr. Slum Lord, a cash-basis taxpayer, owns and operates an apartment building. During Year 1, Mr. Lord received rent payments of $48,000 and security deposits of $5,000. The rental payments included...
-
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...
-
E19.6. Credit Scoring for a Firm with a Ratings Downgrade: Maytag Corporation (Medium) Maytag Corporation is the established manufacturer of washing machines, dryers, dish- washers, and other home...
-
E19.4. Z-Scoring (Easy) Below are ratios for some of the firms that have appeared in this book, for their 1998 fiscal year. Working Retained Capital Earnings Earnings before Interest and Taxes Market...
-
Fruit of the Loom Ltd. fared poorly from 1997 to 1999. Between April 1997 and October. 1999, its stock price dropped from $38 to $3, a 92 percent loss in market value. Fruit of the Loom manufactures...
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App