Question: Question 39 (4 points) What is the Excel function used for dummy-variable coding? Stdev.s function OvLookup function O IF function Dummy Function O Pivot function

Question 39 (4 points) What is the Excel function

Question 39 (4 points) What is the Excel function

Question 39 (4 points) What is the Excel function

Question 39 (4 points) What is the Excel function used for dummy-variable coding? Stdev.s function OvLookup function O IF function Dummy Function O Pivot function Based on the following information, answer the next 2 questions: You're looking at how the different Sales Promotions affect Sales. Thus, the IV is the type of sales promotion. It has 3 levels: 1) Discounts, 2) Free Shipping/Free Returns, and 3) Loyalty Programs. The DV is the average daily sales during the promotion (in $). Question 40 (4 points) Saved How many dummy variables will you have to code for, to fully identify every level of the IV: "Promotion type". 4 3 2 1 Question 41 (4 points) If the dummy-coded variable for "Discounts", reads 1, for day-20, what does that mean? Hint: Any dummy coded variable takes only two values: 0 and 1. On day 20, the "Discount type" promotion was running. Only 1 type of sales promotions was running on day 20. On day 20, the "Discount type" promotion was NOT running. The sales on day 20 was $1

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!