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: 50% (4 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....
-
Bridge City Consulting bought a building and the land on which it is located for $100,000 cash. The land is estimated to represent 60 percent of the purchase price. The company paid $10,000 for...
-
Match the term with its definition by placing the corresponding letter in the space provided: 1. A written promise to pay a specified amount of money at a particular future date 2. The date when...
-
Following are sales and administrative cost data for Big Jack Burgers for the last four months: Administrative cost is a mixed cost, and sale is a potential cost driver. REQUIRED A. Using the...
-
Question 7 Find 2 0 S S 0 3 (2x+5y) dxdy < >
-
You are a senior accountant in a top-tier accounting firm. Your senior manager has asked you to assist your client, Daisy Ltd, in the preparation of consolidated financial statements for the year...
-
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...
-
Highlight the major components of physical distribution and logistics.
-
Hannah manages a store for which she receives \(20 \%\) of any profit earned, so she does well when the store does well and earns nothing if the store incurs a loss. Hannah and the store's owner are...
-
Society uses various rules to decide which allocations are better than others. What rules does the generalized utilitarian welfare function use? If the generalized utilitarian welfare function were...
-
In April 2011, the European Commission found Procter \& Gamble, Unilever, and Henkel, the leading producers of washing powder in Europe, guilty of operating a cartel from 2002 to 2005 in eight...
-
A hub-and-spoke cartel is a collusive relationship between a group of competitors (the spokes) and one (or more) of their common suppliers or customers (the hub). In August 2011, the former Office of...
-
On March 29, 2017, the European Commission blocked a \( 21\) billion merger between the London Stock Exchange and the Deutsche Brse on the grounds that the deal would create a de facto monopoly in...
-
Why would the market economy produce too little education and health care?
-
Select a mass spectrometric technique with the highest mass resolution for identifying an unknown compound being eluted from a liquid chromatography column
-
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...
-
Coding versus Template Strands: The RNA genome of phage Qb is the nontemplate strand, or coding strand, and when introduced into the cell it functions as an mRNA. Suppose the RNA replicase of phage...
-
Jane ate 1 plate of spaghetti with meat balls - 60 grams of carbohydrate, 30 grams of protein and 20 grams of fat. Calculate the total calories and the percentage of each nutrient? a. What is the...
-
The Keratin-71 gene controls dog hair shape. It is on chromosome 27. There are two alleles in the population: KS = straight hair and KC = curly hair. The photo shows a dog with curly hair. rc) If you...
Study smarter with the SolutionInn App