Question: Using PivotTables, find the average and standard deviation of sales in the Sales Transactions database. Also, find the average sales by source (Web or e

Using PivotTables, find the average and standard deviation of sales in the Sales Transactions database. Also, find the average sales by source (Web or e mail). Do you think this information could be useful in advertising? Explain how and why or why not.

Step by Step Solution

★★★★★

3.45 Rating (168 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Sales Transactions Cust ID Region Payment Transaction Code Source Amount Product Time Of Day 10001 East Paypal 93816545 Web 2019 DVD 2219 10002 West Credit 74083490 Web 1785 DVD 1327 10003 North Credi... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

607-B-B-C-B-M (671).xlsx

300 KBs Excel File

Students Have Also Explored These Related Business Communication Questions!

In the Excel file Facebook Survey, use a PivotTable to find the average and standard deviation of hours online/ week and number of friends for females and males in the sample.

For the Excel file Travel Expenses, use a PivotTable to find the average and standard deviation of expenses for each sales rep.

The average and standard deviation of the amount of Goods and Services tax remitted by performance artists in a twelve month period were $5.042 thous and $1.551 thous respectively. If a sample of 110...

Using PivotTables, find the average and standard deviation of sales in the Sales Transactions database. (A-545)

17. Using PivotTables, find the average and standard deviation of sales in the Sales Transactions database. Also, find the average sales by source (Web or e-mail). Do you think this information could...

Score: 0 of 1 pt 7 of 8 (5 complete) 4.8.55 n Using Pivot Tables, find the mean and standard deviation of sales by region Sales Data EI Click the loan to view the data. D Complete the table below....

UTS Business Statistics 26134 Report (Group Assignment) SPRING 2017 Assessment Value: This assignment is worth 20% It is be completed in: A GROUP OF 3, 4 or 5 STUDENTS Due times and dates: Due...

Hi again, I was hoping you can help with this investment management assignment. I am attaching the word document. It is 4 problems about asset management. Thank you for your help! Fin 6310 1. Assume...

Big10Sweaters.com is a new company started last year by two recent college graduates. The idea behind the company was simple. They will sell premium logo sweaters for Big Ten colleges with one major,...

Need to double check my answer thanks Which is not a goal of the ethical data analyst? 2 'Tom's SUV rolled over. SUVs are dangerous." This best illustrates which fallacy? Multiple Choice Multiple...

According to the Centers for Disease Control, 15.2% of American adults experience migraine headaches. Stress is a major contributor to the frequency and intensity of headaches. A massage therapist...

International Human Resource Management: Policies and Practices for Multinational Enterprises. (Ibraiz Tarique, Dennis Briscoe, and Randall Schuler) Case Study 12.1 - Cross-Cultural Performance...

Consider the recursive equation M ( n ) = 3 M ( n - 2 ) + 1 . Expanding the term M ( n - 2 ) once on the right hand side gives M ( n ) as Question 1 0 options: M ( n ) = 9 M ( n - 4 ) + 4 M ( n ) = 3...

The business analysis team has been working hard to meet tight deadlines on their project. The project manager offers them a bonus and some time off if they can meet their deadlines. Which...

Peters Paper Clips uses a three-stage production process: cutting wire to prescribed lengths, inner bending, and outer bending. The cutting process can produce at a rate of 200 pieces per minute;...

In Problem 6, suppose the line is balanced using 12 workstations and a finished product can be produced every 4.5 minutes. a. What is the production rate in units per day? b. What is the assembly...

A small assembly line for the assembly of power steering pumps needs to be balanced. Exhibit 8.11 is the precedence diagram for problems #8 and #9. The cycle time is determined to be 1.5 minutes. How...

How do you calculate the expected value for this goodness of fit test? The Frequency is the observed value how do you compute the expected value in this problem from that The results of a recent...

Conduct the hypothesis test and provide the test statistic and the critical value, and state the conclusion. A person randomly selected 100 checks and recorded the cents portions of those checks. The...

What's the future value of $250,000 after 3 vears if it earns 26% annuallv? What's the present value of $90,000 to be received in 3 years if the annual interest i What annual interest rate would...