Using the file States.xlsx (in the Templates folder), summarize the total sales in each state by year.
Question:
Using the file States.xlsx (in the Templates folder), summarize the total sales in each state by year.
Transcribed Image Text:
1 23 3456780 9 10 11 12 13 14 15 16 17 18 19 20 A Store B Product 20 food 10 cds 6 dvds 4 dvds 6 food 6 books 5 magazines 18 cds 15 magazines 13 food 7 books 3 books 16 food 18 dvds 17 cds 2 books 8 toys 18 dvds 12 food C Date 3/15/2011 11/29/2014 8/11/2010 5/11/2012 7/8/2011 9/7/2011 1/4/2014 9/27/2011 9/29/2014 1/27/2011 4/13/2014 2/17/2010 6/6/2014 11/30/2011 2/5/2010 6/18/2011 6/22/2014 1/27/2013 5/15/2010 D Units E Revenue 37 $16.28 70 $19.60 68 $39.44 120 $92.40 129 $101.91 $2.24 $72.72 $8.04 132 $105.60 38 $23.18 103 $17.51 127 $21.59 129 $29.67 149 $80.46 64 $9.60 $26.46 $12.24 16 101 67 147 72 85 $66.30 32 $15.68
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 40% (5 reviews)
Answered By
Ashington Waweru
I am a lecturer, research writer and also a qualified financial analyst and accountant. I am qualified and articulate in many disciplines including English, Accounting, Finance, Quantitative spreadsheet analysis, Economics, and Statistics. I am an expert with sixteen years of experience in online industry-related work. I have a master's in business administration and a bachelor’s degree in education, accounting, and economics options.
I am a writer and proofreading expert with sixteen years of experience in online writing, proofreading, and text editing. I have vast knowledge and experience in writing techniques and styles such as APA, ASA, MLA, Chicago, Turabian, IEEE, and many others.
I am also an online blogger and research writer with sixteen years of writing and proofreading articles and reports. I have written many scripts and articles for blogs, and I also specialize in search engine
I have sixteen years of experience in Excel data entry, Excel data analysis, R-studio quantitative analysis, SPSS quantitative analysis, research writing, and proofreading articles and reports. I will deliver the highest quality online and offline Excel, R, SPSS, and other spreadsheet solutions within your operational deadlines. I have also compiled many original Excel quantitative and text spreadsheets which solve client’s problems in my research writing career.
I have extensive enterprise resource planning accounting, financial modeling, financial reporting, and company analysis: customer relationship management, enterprise resource planning, financial accounting projects, and corporate finance.
I am articulate in psychology, engineering, nursing, counseling, project management, accounting, finance, quantitative spreadsheet analysis, statistical and economic analysis, among many other industry fields and academic disciplines. I work to solve problems and provide accurate and credible solutions and research reports in all industries in the global economy.
I have taught and conducted masters and Ph.D. thesis research for specialists in Quantitative finance, Financial Accounting, Actuarial science, Macroeconomics, Microeconomics, Risk Management, Managerial Economics, Engineering Economics, Financial economics, Taxation and many other disciplines including water engineering, psychology, e-commerce, mechanical engineering, leadership and many others.
I have developed many courses on online websites like Teachable and Thinkific. I also developed an accounting reporting automation software project for Utafiti sacco located at ILRI Uthiru Kenya when I was working there in year 2001.
I am a mature, self-motivated worker who delivers high-quality, on-time reports which solve client’s problems accurately.
I have written many academic and professional industry research papers and tutored many clients from college to university undergraduate, master's and Ph.D. students, and corporate professionals. I anticipate your hiring me.
I know I will deliver the highest quality work you will find anywhere to award me your project work. Please note that I am looking for a long-term work relationship with you. I look forward to you delivering the best service to you.
3.00+
2+ Reviews
10+ Question Solved
Related Book For
Microsoft Excel Data Analysis And Business Modeling
ISBN: 9780137613663
7th Edition
Authors: Wayne Winston
Question Posted:
Students also viewed these Business questions
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
The following transactions for Kramer Corporation occurred during December of the current year. Follow the step-by-step instructions to enter the transactions, process the adjusting entries, and...
-
Emerald Fashion may be a high-end clothing store found in a little Tennessee town. Emerald has only one store, which is found within the shopping locale by the town square. Emerald enjoys the...
-
Sewing industries is a factory located in Divundu that specialises in assembling mini-sewing electrical machines which are portable and which can be used in close proximity. The business has provided...
-
On October 1, 2014, Pacer Corp. acquired all of Sunny Corp.s outstanding stock for cash. The fair value of Sunnys net assets was less than the purchase price but more than the net carrying amount....
-
The Award Plus Company manufactures medals for winners of athletic events and other contests. Its manufacturing plant has the capacity to produce 10,000 medals each month. Current production and...
-
When a control chart is first constructed, why are the centerline and control limits treated as trial values?
-
The Kelly Services, Inc., and Subsidiaries statements of earnings from its 2008 annual report are presented in Exhibit 5-4. Required a. Using the statements of earnings, prepare a vertical...
-
Cash Beginning inventory Common stock Retained earnings $80,100 33,000 (220 units 3150) se, een 63,10 Ook The following five transactions occurred in Year 2 1. First purchase (cash) 150 units @ $155...
-
Skylar and Walter Black have been married for 25 years. They live at 883 Scrub Brush Street, Apt. 52B, Las Vegas, NV 89125. Skylar is a stay-at-home parent and Walt is a high school teacher. Skylars...
-
Using the named Storesales.txt, summarize the total revenue by store, and create a slicer for the Store field. 1 23 3456780 9 10 11 12 13 14 15 16 17 18 19 20 A Store B Product 20 food 10 cds 6 dvds...
-
The file named Faberu.xlsx contains salaries, travel expenses, faculty ID, department code, and faculty code for all the business-school faculty. Use this data to answer the following questions. Use...
-
Assume that the quantity of ending inventory is larger than the quantity of beginning inventory and that the lifo method is being used. Would operating income using direct costing be different from...
-
Solve (c) 8 WI n=1 5 cos n N5
-
- Pierce Company reported net income of $160,000 with income tax expense of $19,000 for 2020. Depreciation recorded on buildings and equipment amounted to $80,000 for the year. Balances of the...
-
ABC Company had the following results as of 12/31/2020: ABC's hurdle rate is 10% CONTROLLABLE REVENUE CONTROLLABLE COST CONTROLLABLE ASSETS CONTROLLABLE INCOME 21. What is the division's margin? A....
-
A gray kangaroo can bound across a flat stretch of ground with each jump carrying it 10 m from the takeoff point. If the kangaroo leaves the ground at a 20 angle, what are its (a) takeoff speed and...
-
Since 1900, many new theories in physics have changed the way that physicists view the world. Create a presentation that will explain to middle school students why Quantum Mechanics is important, how...
-
Brown limited is considering the financial viability of an investment project. The internal rate of return for the project is 13%. While this rate is higher than the market rate, the management would...
-
A seasonal index may be less than one, equal to one, or greater than one. Explain what each of these values would mean.
-
Tango Corporation, a calendar year taxpayer, has been an S corporation for several years. Tangos business activities have become very profitable in recent years. On June 16, 2017, its sole...
-
Orlando Corporation, a calendar year taxpayer, has been an S corporation for several years. On July 9, 2017, Orlando authorizes a second class of nonvoting preferred stock that pays a 10% annual...
-
Voyles Corporation, a calendar year taxpayer formed five years ago, desires to make an S election beginning in 2017. Sue and Andrea each own one-half of the Voyles stock. a. How does Voyles make the...
-
The payroll register of Ruggerio Co. indicates $13,800 of social security withheld and $3,450 of Medicare tax withheld on total salaries of $230,000 for the period. Federal withholding for the period...
-
All of the following are included on Form 1040, page 1, EXCEPT: The determination of filing status. The Presidential Election Campaign check box. The income section. The paid preparer signature line.
-
Question One: (25 marks) (X) Inc. purchased 80% of the outstanding voting shares of (Y) for $360,000 on July 1, 2017. On that date, (Y) had common shares and retained earnings worth $180,000 and...
Study smarter with the SolutionInn App