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

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