Learning Goal: I’m working on a data analytics spreadsheet and need an explanation and answer to help me learn.Assignment #5 Part A Sales Transaction data Create a PivotTable for “count of regional sales by product” (Hint: similar to the energy drink example) using the data provided. Type in the answers to the following two questions below the PivotTable.

Find the marginal probabilities that a sale originated in each of the four regions and the marginal probability of each type of sale (book or DVD).

Find the conditional probabilities of selling a book given that the customer resides in each region.

Part B Canadian Business School Demographics Construct a joint probability table below the original data.

Calculate the marginal probabilities.

What is the probability that a female student is from outside Canada or the United States?

Part C SAT Scores The distribution of SAT scores in math for an incoming class of business students has a mean of 610 and standard deviation of 20. Assume that the scores are normally distributed. Find the probability that an individual’s SAT score is less than 600

Find the probability that an individual’s SAT score is between 590 and 620.

Find the probability that an individual’s SAT score is greater than 650 (Hint: find the probability for “less than 650” first).

Find the standard values (z-score) for students scoring 540, 600, 650, 700 on the test. Explain what this means.

Hint: use the function =NORM.DIST(X, mean, STD, 1). X=600 Hint: z-score= (observation-mean)/standard deviation

Requirements: an hour

The price is based on these factors:

Academic level

Number of pages

Urgency

Basic features

- Free title page and bibliography
- Unlimited revisions
- Plagiarism-free guarantee
- Money-back guarantee
- 24/7 support

On-demand options

- Writer’s samples
- Part-by-part delivery
- Overnight delivery
- Copies of used sources
- Expert Proofreading

Paper format

- 275 words per page
- 12 pt Arial/Times New Roman
- Double line spacing
- Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Delivering a high-quality product at a reasonable price is not enough anymore.

That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more
## Recent Comments