1000 points
Do all of these problems in a single Excel Workbook. Solve each problem on a separate Worksheet. Your Excel File must be setup like you did in Formative01 with appropriate Worksheet tab names.
(200) When done, upload your file, named Summative05.xlsx, to the D2L Assignment Folder 'Summative05'.
Filtering-Chapter 49, Problem 6
Refer to the file makeupfilter.xlsx
Find all transactions in which Zaret or Betsy sold lipstick or foundation.
Data Consolidation-Chapter 50, Problem 2
Use these two files: JANcon.xlsx and FEBcon.xlsx
Create a consolidated worksheet that gives by region the largest first-quarter transaction for each product from the standpoint of revenue and units sold.
Subtotals-Chapter 51, Problem 5
The data for this problem is in the file MakeupSubtotals.xlsx Use the Subtotals command to compute the following: (50) 3. Total lip gloss units sold for Hallagan (50) 4. Grand total number of units sold (50) 5. Salesperson with largest transaction (in terms of revenue) for eye liner (50) 6. Salesperson Ashley lipstick dollar amount total
Charting Tricks-Chapter 52, Problem 1
Refer to the file Cakes.xlsx
Create a combination chart with a secondary axis to summarize monthly salespeople and revenues.
Linear Relationships-Chapter 53, Problem 1
The file DellData.xlsx contains monthly returns for the S&P (Standard and Poor's) stock index and Dell. The beta of a stock is defined to be the slope of the least-squares line used to predict monthly return for a stock from monthly return for the market.
Exponential Growth-Chapter 54, Problems 2,3,4,5
(50) 12. For Wal-Mart, use the trend curve to predict 2010 revenue.
Power Curve-Chapter 55, Problem 1
Use the fax machine data to model the relationship between cumulative fax machines produced and total production cost.
Correlations-Chapter 56, Problem 2
(50) 14. Find and interpret the correlations between these quantities.
(100) 15. Combine your four screen shots from the previous exercises in order into one .pdf file named Summative05ScreenShots.pdf and upload this file to the D2L Dropbox folder 'Summative05 Screen Shots'