MKT 200 PRACTICE EXAM QUESTIONS AND
DETAILED SOLUTIONS 2026
▶ pre-test Answer: find problem prior to full launch
▶ experimental Answer: test cause and effect relationship
subject --> cause --> effect
▶ organize Answer: dif types of data
▶ tidy data Answer: One observation per row
One variable per column
One unit of observation per table
▶ other types of data Answer: Nominal = categories, (ex. male / females)
Ordinal = order , ( ex. ratings / rankings)
Interval = equal distance between points (ex. temperature)
Ratio = absolute zero, weight (ex. income)
▶ vizualize Answer: Ex. Data Camp - data visualization in spreadsheets
▶ analyze Answer: What data points would you want to analyze?
Ex. Google analytics
- App and web property type with new abilities, easier and more powerful
- Collect up to 500 dif events
- Slice the data multiple ways
- Understanding customers as they engage with your business
▶ conversion rate Answer: # of orders / # of views
-Doesn't have to be sales
, -Viewing online or instore affects conversion rate
High views but low sales = customers don't like the product or page layout
Low views but high sales = advertise more and add products to the home
page
4 sales / 10 views = 40%
▶ average order value Answer: total revenue / total orders
-See how much a customer is spending on average
-Increase the AOV cap to reach free shipping
$5,939 total revenue / 104 total orders = $57.10
▶ Shopping Cart Abandonment Answer: ppl who added to cart but didn't
complete checkout / total people with items in cart
-Why are ppl bailing?
-Add free shipping
-Price match
▶ IBM Answer: Portraits of a Smarter Plants
•Take advantage of data and then turn it into insight
•Analytics potential data possibilities
•Unstructured data
Ex. tweets ... don't know what the words mean
•Churn - telecommunication
-Percent of customers that don't come back
Ex. season ticket turnover ... how do we retain them?
•Look at data to see where there are opportunities
▶ STP Answer: segmentation
targeting
positioning
▶ segmentation Answer: divide mkt into distinct groups
-Demographic ... age, gender, income, occupation, location
-Psychographic ... lifetstyle, personality, values, interests
DETAILED SOLUTIONS 2026
▶ pre-test Answer: find problem prior to full launch
▶ experimental Answer: test cause and effect relationship
subject --> cause --> effect
▶ organize Answer: dif types of data
▶ tidy data Answer: One observation per row
One variable per column
One unit of observation per table
▶ other types of data Answer: Nominal = categories, (ex. male / females)
Ordinal = order , ( ex. ratings / rankings)
Interval = equal distance between points (ex. temperature)
Ratio = absolute zero, weight (ex. income)
▶ vizualize Answer: Ex. Data Camp - data visualization in spreadsheets
▶ analyze Answer: What data points would you want to analyze?
Ex. Google analytics
- App and web property type with new abilities, easier and more powerful
- Collect up to 500 dif events
- Slice the data multiple ways
- Understanding customers as they engage with your business
▶ conversion rate Answer: # of orders / # of views
-Doesn't have to be sales
, -Viewing online or instore affects conversion rate
High views but low sales = customers don't like the product or page layout
Low views but high sales = advertise more and add products to the home
page
4 sales / 10 views = 40%
▶ average order value Answer: total revenue / total orders
-See how much a customer is spending on average
-Increase the AOV cap to reach free shipping
$5,939 total revenue / 104 total orders = $57.10
▶ Shopping Cart Abandonment Answer: ppl who added to cart but didn't
complete checkout / total people with items in cart
-Why are ppl bailing?
-Add free shipping
-Price match
▶ IBM Answer: Portraits of a Smarter Plants
•Take advantage of data and then turn it into insight
•Analytics potential data possibilities
•Unstructured data
Ex. tweets ... don't know what the words mean
•Churn - telecommunication
-Percent of customers that don't come back
Ex. season ticket turnover ... how do we retain them?
•Look at data to see where there are opportunities
▶ STP Answer: segmentation
targeting
positioning
▶ segmentation Answer: divide mkt into distinct groups
-Demographic ... age, gender, income, occupation, location
-Psychographic ... lifetstyle, personality, values, interests
