Recall from an example in the previous chapter that the file Supermarket Transactions.xlsx contains over 14,000 transactions made by supermarket customers over a period of approximately two years. Set up a single pivot table and corresponding pivot chart, with some instructions to a user (like the supermarket manager) in a text box, on how the user can get answers to any typical question about the data. For example, one possibility (of many) could be total revenue by product department and month, for any combination of gender, marital status, and homeowner.
Answer to relevant QuestionsThe file S03_15.xlsx contains monthly data on the various components of the Consumer Price Index.a. Create differences for each of the variables. You can do this quickly with StatTools, using theDifference item in the Data ...Bank 98 operates a main location and three branch locations in a medium-size city. All four locations perform similar services, and customers typically do business at the location nearest them. The bank has recently had more ...In a study designed to gauge married women’s participation in the workplace today, the data provided in the file S04_05.xlsx were obtained from a sample of 750 randomly selected married women. Consider a woman selected at ...A construction company has to complete a project no later than three months from now or there will be significant cost overruns. The manager of the construction company believes that there are four possible values for the ...Betting on a football point spread works as follows. Suppose Michigan is favored by 17.5 points over Indiana. If you bet a “unit” on Indiana and Indiana loses by 17 or less, you win $10. If Indiana loses by 18 or more ...
Post your question