Using PivotTables, find the average and standard deviation of sales in the Sales Transactions database. Also, find
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 mail). Do you think this information could be useful in advertising? Explain how and why or why not.
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 78% (14 reviews)
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 the full answer
Answered By
Aysha Ali
my name is ayesha ali. i have done my matriculation in science topics with a+ . then i got admission in the field of computer science and technology in punjab college, lahore. i have passed my final examination of college with a+ also. after that, i got admission in the biggest university of pakistan which is university of the punjab. i am studying business and information technology in my university. i always stand first in my class. i am very brilliant client. my experts always appreciate my work. my projects are very popular in my university because i always complete my work with extreme devotion. i have a great knowledge about all major science topics. science topics always remain my favorite topics. i am also a home expert. i teach many clients at my home ranging from pre-school level to university level. my clients always show excellent result. i am expert in writing essays, reports, speeches, researches and all type of projects. i also have a vast knowledge about business, marketing, cost accounting and finance. i am also expert in making presentations on powerpoint and microsoft word. if you need any sort of help in any topic, please dont hesitate to consult with me. i will provide you the best work at a very reasonable price. i am quality oriented and i have 5 year experience in the following field.
matriculation in science topics; inter in computer science; bachelors in business and information technology
_embed src=http://www.clocklink.com/clocks/0018-orange.swf?timezone=usa_albany& width=200 height=200 wmode=transparent type=application/x-shockwave-flash_
4.40+
11+ Reviews
14+ Question Solved
Related Book For
Business Analytics Methods Models and Decisions
ISBN: 978-0321997821
2nd edition
Authors: James R. Evans
Question Posted:
Students also viewed these 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...
-
For Table 24.1, suppose you think that you omitted a relevant variable, physicians per capita. Would this harm your results for S or H? Explain your view. Table 24.1 (Model 1) The Effect of Community...
-
What causes the symptoms of staphylococcal food poisoning? Why are cases of staph food poisoning often linked to a food preparer with an open hand wound?
-
Assume that the retaining wall shown in Figure 13.36 is frictionless. For each problem, determine the Rankine passive force per unit length of the wall, the variation of active earth pressure with...
-
Determine the total bare-module cost for the flowsheet in Figure 16.21 at ambient temperature and pressure. Use \(\mathrm{CE}=600\). Design Specifications Pumps: reciprocating, motor driven, 25 psia...
-
Chief executive officer compensation can be a material amount and is often scrutinized by regulators, analysts, competitors, and investors. For CEOs of publicly traded companies, compensation can...
-
To estimate the value of Paul's investment at maturity, calculate the number of years until Paul will go to university, and use compound interest to calculate the value of Paul's investment at that...
-
The following sample information was obtained by taking four doughnuts per hour for twelve hours from Fawcett Bakerys doughnut process and weighing them: For the data shown above a. Find the x and R...
-
In the Excel file Cell Phone Survey, use PivotTables to find the average for each of the numerical variables for different cell phone carriers and gender of respondents.
-
In the Excel file Facebook Survey, find the average and median hours online/ week and number of friends in the sample using the appropriate Excel functions. Compute the midrange and compare all...
-
What are the net fixed assets for the years 2016 and 2017? Use the data from the following financial statements: Partial Income Statement Year Ending 2017 Sales Revenue S350,000 COGS $140,000 Fixed...
-
Ruth Moore and Carl Nies have to do a class presentation on the pension pronouncement Employee Benefits. In developing the class presentation, they decided to provide the class with a series of...
-
Waterworld Company leased equipment from Costner Company. The lease term is 4 years and requires equal rental payments of \($43\),019 at the beginning of each year. The equipment has a fair value at...
-
Devers Corporation issued 400,000 of 6% bonds on May 1, 2015. The bonds were dated January 1, 2015, and mature January 1, 2017, with interest payable July 1 and January 1. The bonds were issued at...
-
The following information is available for the pension plan of Radcliffe Company for the year 2015. Instructions (a) Compute pension expense for the year 2015. (b) Prepare the journal entry to record...
-
Accounting, Analysis, and Principles Instar Company has several investments in other companies. The following information regarding these investments is available at December 31, 2015. 1. Instar...
-
Refer to the Baseball 2021 data, which report information on the 30 Major League Baseball teams for the 2021 season. Consider the following variables: number of wins, payroll, season attendance,...
-
What kind of rays are X-rays?
-
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...
-
Have a brief introduction, discussion of the topics/points, and a conclusion.what you have learned during the course( Organizational Dynamics and Effectiveness).Their relevance to your career....
-
Using the article provided below, you are required to analyse the company information to define the business goals and evaluate whether the supply chain is a strategic fit with the business and...
-
Create output that shows a scatterplot with a line of best fit for your data. Explain what a line of best fit is? Submit both the output file (SPSS) as well as your Word summary.
Study smarter with the SolutionInn App