Question: fQUESTION 3 Questions #3-8: Create a correlation table using the Data Analysis function in Excel including the following variables: Amount purchased, Frequency, Last purchase, First

 \fQUESTION 3 Questions #3-8: Create a correlation table using the DataAnalysis function in Excel including the following variables: Amount purchased, Frequency, Lastpurchase, First purchase, P_Child, P_Youth, P_Cook, P_DIY, and P_Art. 3. Given these

\fQUESTION 3 Questions #3-8: Create a correlation table using the Data Analysis function in Excel including the following variables: Amount purchased, Frequency, Last purchase, First purchase, P_Child, P_Youth, P_Cook, P_DIY, and P_Art. 3. Given these results, which two variables are least correlated? O Frequency and P_Art Frequency and P_Cook First purchase and Last purchase Amount purchased and Frequency O P_DIY and Amount purchased O P_DIY and P_Cook QUESTION 4 4. What variable is "P_Child" most strongly correlated with? (Type in the exact name of the variable as presented in the correlation output). QUESTION 5 5. What correlation value did you come up with for "P_Cook" and "First Purchase"?1. What type of scale is \"Amount purchased\" on? Ratio Interval O Ordinal Nominal QUESTION 2 2. What type of scale is \"Gender\" on? Ordinal Interval Ratio 0 Nominal

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 Marketing Questions!