Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Aug 29, 2024

1 Create a Pivot Table creating pivot table Sports Qtr Sales Golf 3 1500 Golf 4 2500 Tennis 3 3450 Tennis 4 5500 Tennis 3

1 Create a Pivot Table

creating pivot table

Sports

Qtr

Sales

Golf

1500

Golf

2500

Tennis

3450

Tennis

5500

Tennis

6500

Tennis

2500

Golf

1500

Golf

2000

Football

5000

Football

8000

Q 2 do a quick analysis

1. Total Q1 sales

2. Average of Tele industries

Company

Industry

Q1Sales

Q2Sales

BMW

auto

450000

485000

Nissan

auto

350000

375000

Toyota

auto

250000

350000

CP 24

Media

100000

130000

GSK

Pharma

150000

125000

Pfyzer

Pharma

200000

250000

Apple

tech

245000

265000

Samsung

tech

120000

245000

3mobile

tele

130000

345000

Orange

tele

130000

230000

Virgin

tele

175000

275000

Step by Step Solution

There are 3 Steps involved in it

Step: 1

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

Step: 3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals Of Quality Auditing

Authors: B. Scott Parsowith

1st Edition

0873892402, 978-0873892407

More Books

Students also viewed these Accounting questions

Question

★★★★★

Jill operates a sporting goods store in a rented location at a shopping mall. She is insured under a CGL policy with the following limits: General aggregate limit ............. $1,000,000...

Answered: 1 week ago

Question

★★★★★

On January 1, Sandy borrows $40,000 from G&H Accounting firm, her employer, to pay-off charge accounts and other personal loans. Sandy must repay the $40,000 loan at the end of 5 years. Because Sandy...

Answered: 1 week ago

Question

★★★★★

=+7.1. A gambler with initial capital a plays until his fortune increases b units or he is ruined. Suppose that p > 1. The chance of success is multiplied by 1 + 8 if his initial capital is infinite...

Answered: 1 week ago

Question

★★★★★

1. Analyze the ethical culture at TAP. Does the culture appear to be in alignment? Misalignment? 2. Based on the facts in the case and what you have learned in this chapter, evaluate the culture...

Answered: 1 week ago

Question

★★★★★

Completion: Complete each statement 1- Wireless communication is the process of 2- Security is the combination of processes, procedures and systems used to 3- Confidentiality is 4- Integrity protects...

Answered: 1 week ago

Question

★★★★★

1. For a time series with horizontal pattern, methods that are generally used for forecasting are: a. Simple linear regression and multiple regression b. Holt's linear exponential smoothing c. Moving...

Answered: 1 week ago

Question

★★★★★

Any help plz short-essay questions 1. Describe the socialization process of a new recruit. Why is this an important process for a new hire? 1. List of reasons as to why sales organization to train...

Answered: 1 week ago

Question

★★★★★

Question 9 (10 points) Innovative work behavior refers to an "everyday innovation" dependent on the employees' intentional demands. True False

Answered: 1 week ago

Question

★★★★★

we discussed material from the book "Scrum Mastery + Agile Leadership". Specifically, we discussed the "three platinum principles" upon which leadership in Agile is based. These principles include:...

Answered: 1 week ago

Question

★★★★★

Some of the elementary students have had pre-K enrichment and others have not. We notice a possible split based on Type of Neighborhood (urban, suburban, rural) and construct the following...

Answered: 1 week ago

Question

★★★★★

DBG Company has just added a new division in to manufacture specially designed classroom desk to facilitate the use technological devices in schools. It has prepared the following data for the year...

Answered: 1 week ago

Question

★★★★★

5. Work Rules. CCH, a Wolters Kluwer company, provides a business owners toolkit through their Tax and Accounting service. CCH is a leading provider of business, legal, and tax information. Locate...

Answered: 1 week ago

Question

★★★★★

3. What type of evidence are the e-mails received from employees about Gatess on-duty behavior? Should this evidence be considered by the arbitrator? Why or why not? Background On March 30, 2006,...

Answered: 1 week ago

Question

★★★★★

4. Should the Companys offer to pay back pay and to restore seniority and benefits if Gates is found not guilty be considered by the arbitrator? Why or why not? Background On March 30, 2006, David...

Answered: 1 week ago

Previous Question Next Question