Assignment 12:10
12-10 This project gives you an opportunity to learn how to use Excel’s PivotTable feature to analyze a database or data list. Use the data file for Online Management Training Inc. described earlier in the chapter. This is a list of the sales transactions at OMT for one day. You can find this spreadsheet file at MyLab MIS. Use Excel’s PivotTable to help you answer the following questions:
§ Where are the average purchases higher? The answer might tell managers where to focus marketing and sales resources or pitch different messages to different regions.
Don't use plagiarized sources. Get Your Custom Essay on
Assignment 12:10
Just from $13/Page
§ What form of payment is the most common? The answer could be used to emphasize in advertising the most preferred means of payment.
§ Are there any times of day when purchases are most common? Do people buy more products while at work (likely during the day) or at home (likely in the evening)?
§ What’s the relationship between region, type of product purchased, and average sales price?
We provide instructions on how to use Excel PivotTables in our Learning Tracks.
a. Upload your pivot table(s) along with short explanations on multiple worksheets when addressing the bulleted questions. Excel question file attached.
Calculator
Our features
We've got everything to become your favourite writing service
Money back guarantee
Your money is safe. Even if we fail to satisfy your expectations, you can always request a refund and get your money back.
Confidentiality
We don’t share your private information with anyone. What happens on our website stays on our website.
Our service is legit
We provide you with a sample paper on the topic you need, and this kind of academic assistance is perfectly legitimate.
Get a plagiarism-free paper
We check every paper with our plagiarism-detection software, so you get a unique paper written for your particular purposes.
We can help with urgent tasks
Need a paper tomorrow? We can write it even while you’re sleeping. Place an order now and get your paper in 8 hours.
Pay a fair price
Our prices depend on urgency. If you want a cheap essay, place your order in advance. Our prices start from $11 per page.