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: 66% (3 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....
-
Frusciante, Inc., has 290,000 bonds outstanding. The bonds have a par value of $1,000, a coupon rate of 7 percent paid semiannually, and 8 years to maturity. The current YTM on the bonds is 7.5...
-
Refer to the information in Exercise 17-7 to answer the following requirements. Required 1. Using ABC, compute the overhead cost per unit for each product line. 2. Determine the total cost per unit...
-
Barley Hopp, Inc., manufactures custom-ordered commemorative beer steins. Its standard cost information follows: Barley Hopp had the following actual results last year: Number of units produced and...
-
6. Even though the Kraus representation gives an "internal" view of the dynamics of the open system Q, the Kraus operators contain some information about the environment. Concretely, let & be an...
-
Consider the hypothetical eutectic phase diagram for metals A and B, which is similar to that for the lead-tin system, Figure 9.8. Assume that (1) and phases exist at the A and B extremities of the...
-
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...
-
A 0.1-kg yo-yo consists of two solid disks of radius 10 cm joined together by a massless rod of radius 1 cm and a string wrapped around the rod. One end of the string is held fixed and is under...
-
What is the estate-tax-free transfer threshold for 2012 and 2013, and how does this relate to the unified tax credit?
-
Contact three law firms to determine the cost of preparing a simple will and the kinds of information needed by the attorney. Prepare a report of your findings.
-
With the availability of free credit reports, consumers are encouraged to check their report every 4 months-one report from each of the three major bureaus. In the past, consumers also were...
-
Why is Principle 1: The Best Protection Is Knowledge so important when choosing a broker?
-
A leading financial publication reported that the average baby boomer credit user will pay approximately $1,200 in interest annually. If, instead of paying interest, this amount was saved every year,...
-
Assume the same information for Global Defence as in Exercise 19-14, except that Global Defence uses a 90% incremental unit-time learning model as a basis for predicting direct manufacturing...
-
If the amplifier indicated by the box input impedance of oo, which of the following statements are true ? has an open loop gain as well as Feedback factor (\beta = 1/ R_1\) The feedback is voltage...
-
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...
-
Suppose you visit a small branch of Bank of Sultanate in South Mawaleh that operates a single server with an exponential service time that has rate 1 transaction every 5 minutes. Arrivals at this...
-
In July 2020, a brawl involving approximately 12 adults took place in the hotel lobby of the Seminole Hard Rock Hotel & Casino in Florida.6 Although unproved at the time of writing, it is alleged...
-
Provide a statement explaining your own personal code of ethics. Include at least 4 codes in your answer with enough explanation and examples. In addition, discuss whether the personal code of ethics...
Study smarter with the SolutionInn App