PelicanStores_Practice Exam

Items Net Sales Gender Age 1 Regular 1 39.50 Discover Male Married 32 2 Promotional 1 102.40 Proprietary Card Female Married 36 3 Regular 1 22.50 Proprietary Card Female Married 32 4 Promotional 5 100.40 Proprietary Card Female Married 28 5 Regular 2 54.00 MasterCard Female Married 34 6 Regular 1 44.50 MasterCard Female Married 44 7 Promotional 2 78.00 Proprietary Card Female Married 30 8 Regular 1 22.50 Visa Female Married 40 9 Promotional 2 56.52 Proprietary Card Female Married 46 10 Regular 1 44.50 Proprietary Card Female Married 36 11 Regular 1 29.50 Proprietary Card Female Married 48 12 Promotional 1 31.60 Proprietary Card Female Married 40 13 Promotional 9 160.40 Visa Female Married 40 14 Promotional 2 64.50 Visa Female Married 46 15 Regular 1 49.50 Visa Male Single 24 16 Promotional 2 71.40 Proprietary Card Male Single 36 17 Promotional 3 94.00 Proprietary Card Female Single 22 18 Regular 3 54.50 Discover Female Married 40 19 Promotional 2 38.50 MasterCard Female Married 32 20 Promotional 6 44.80 Proprietary Card Female Married 56 21 Promotional 1 31.60 Proprietary Card Female Single 28 22 Promotional 4 70.82 Proprietary Card Female Married 38 23 Promotional 7 266.00 American ExpressFemale Married 50 24 Regular 2 74.00 Proprietary Card Female Married 42 25 Promotional 2 39.50 Visa Male Married 48 26 Promotional 1 30.02 Proprietary Card Female Married 60 27 Regular 1 44.50 Proprietary Card Female Married 54 28 Promotional 5 192.80 Proprietary Card Female Single 42 29 Promotional 3 71.20 Proprietary Card Female Married 32 30 Promotional 1 18.00 Proprietary Card Female Married 70 31 Promotional 2 63.20 MasterCard Female Married 28 32 Regular 1 75.00 Proprietary Card Female Married 52 33 Promotional 3 63.20 Proprietary Card Female Married 44 34 Regular 1 40.00 Proprietary Card Female Married 34 35 Promotional 5 105.50 MasterCard Female Married 56 36 Regular 1 29.50 MasterCard Male Single 36 37 Regular 2 102.50 Visa Female Single 42 38 Promotional 6 117.50 Proprietary Card Female Married 50 39 Promotional 5 13.23 Proprietary Card Female Married 44 Custome r Type of Customer Method of Payment Marital Status

40 Regular 2 52.50 Proprietary Card Female Married 58 41 Promotional 13 198.80 Proprietary Card Female Married 42 42 Promotional 4 19.50 Visa Female Married 46 43 Regular 2 123.50 Proprietary Card Female Married 48 44 Promotional 1 62.40 Proprietary Card Female Married 54 45 Promotional 2 23.80 Proprietary Card Female Married 38 46 Promotional 2 39.60 Proprietary Card Female Married 60 47 Regular 1 25.00 MasterCard Female Married 46 48 Promotional 3 63.64 Proprietary Card Female Married 30 49 Promotional 1 14.82 Proprietary Card Female Married 32 50 Promotional 9 145.20 MasterCard Female Married 46 51 Promotional 6 176.62 Proprietary Card Female Married 38 52 Promotional 5 118.80 Proprietary Card Male Married 68 53 Regular 1 58.00 Discover Female Single 78 54 Regular 2 74.00 Visa Female Single 20 55 Regular 2 49.50 MasterCard Female Married 32 56 Promotional 3 141.60 Proprietary Card Female Married 38 57 Promotional 6 123.10 Proprietary Card Female Married 54 58 Promotional 2 80.40 Proprietary Card Female Married 48 59 Promotional 4 65.20 MasterCard Female Married 46 60 Promotional 4 113.00 Proprietary Card Female Single 50 61 Promotional 1 108.80 Proprietary Card Female Married 46 62 Promotional 3 59.91 Proprietary Card Female Single 30 63 Promotional 5 53.60 Proprietary Card Female Married 54 64 Promotional 1 31.60 Proprietary Card Female Single 42 65 Promotional 2 49.50 Proprietary Card Female Married 48 66 Promotional 1 39.60 Proprietary Card Female Married 62 67 Promotional 2 59.50 Proprietary Card Female Married 34 68 Promotional 5 146.80 Proprietary Card Female Married 28 69 Promotional 2 47.20 Proprietary Card Male Married 46 70 Promotional 8 95.05 Proprietary Card Female Married 54 71 Promotional 5 155.32 Proprietary Card Female Married 30 72 Promotional 4 58.00 MasterCard Female Married 32 73 Regular 1 69.00 Proprietary Card Female Single 22 74 Promotional 2 46.50 Proprietary Card Female Married 32 75 Promotional 2 45.22 Proprietary Card Female Married 74 76 Promotional 4 84.74 Proprietary Card Female Married 62 77 Regular 2 39.00 Proprietary Card Female Married 42 78 Promotional 4 111.14 Proprietary Card Female Married 28 79 Promotional 3 86.80 Proprietary Card Female Married 38 80 Regular 2 89.00 Discover Female Married 54

1 2 3 4 (8 Points) Describe the variables in the data. Think of explaining it to your Type your answer below: Questions 1 – 4 (34 Points) are related to the “Data” Worksheet in th The data was collected from a sample of 93 customer transactions. You need to place all your answers right under each question below, (10 Points) Explain the variable net sales by discussing (4 Points) its distribution (4 Points) and numerical measures (2 Points). Use appropriate statistical tools that should be the most effective in this explanation. Show your work within the stipulated space beside this box. Use 4-5 bullet points to make your discussion precise and concise. Type your discussion below: Start by creating a histogram to visualize the distribution. Use a box plot to check for outliers and understand spread. Calculate skewness and kurtosis to assess the shape of the distribution. Compute the mean, median, standard deviation, and range for numerical measures. (3 Points) Develop using a contingency table with variables age and gender. Show (3 Points) In 2-3 bullet points, what can you conclude regarding the relationship Most customers fall into the age groups between 30 and 49, with the 30-3 Among these age groups, females are the dominant gender. The youngest customers (under 30) and the oldest customer group (60+) While gender distribution varies across age groups, it's clear that more fe This information can help in tailoring marketing strategies and product off (10 Points) Find out if age has any impact on sales by using the appropriate statis (5 Points), and discuss the strength of the relationship (i.e., is this strong or weak work within the stipulated space beside this box. (3 Points) In 1-2 bullet points, what can you conclude that provides the PelicanS management can use to set their sales strategy? Type your discussion below:

a tells. Use 4-5 bullet points and make your discussion precise and concise. tly female customer base.

Binomial Distribution: The binomial distribution models the number of successes (usually deno It is used for discrete data, where each trial is independent and has the The probability mass function for the binomial distribution is given by: P( Common examples include the number of heads obtained in a se Poisson Distribution: The Poisson distribution models the number of events that occur in a fix It is used for rare events where the average rate of occurrence is known The probability mass function for the Poisson distribution is given by: P(X Examples include the number of customer arrivals at a store in a Exponential Distribution: The exponential distribution models the time between successive events It is used for continuous data and is often used to model waiting times o The probability density function for the exponential distribution is given Examples include the time between arrivals of customers at a se Normal Distribution (Gaussian Distribution): The normal distribution is a continuous, symmetric, and bell-shaped dist It is characterized by its mean (μ) and standard deviation (σ) and is ofte The probability density function for the normal distribution is given by: f( Examples include the distribution of heights, weights, or IQ scor

oted as "k") in a fixed number of trials ("n") with two possible outcomes (succe same probability of success. (X = k) = (n choose k) * p^k * (1-p)^(n-k). eries of coin flips (success = heads, failure = tails) or the number of d xed interval of time or space. n and constant. X = k) = (e^(-λ) * λ^k) / k!, where λ is the average rate of occurrence. an hour or the number of emails received in a day. s in a Poisson process (events occur independently at a constant average rate or lifetimes. by: f(x|λ) = λ * e^(-λx), where λ is the rate parameter. ervice center or the lifespan of electronic components. tribution. en used to model data that clusters around a central value. (x|μ,σ) = (1 / (σ√(2π))) * e^(-(x-μ)^2 / (2σ^2)). res in a population.