A_ Plus Writer ONLY!!!!

toothpaste_data_5_all_is_fixed.xlsm

Home >Business & Finance homework help >Marketing homework help >A_ Plus Writer ONLY!!!!

Ave Diff

2 Group Averages Difference Test Analysis Results
					Statistical Values
In a week, how many times do you go to the store?	0 to 1	2 to 3	Difference	Equal?*	F/Sig	t	df	Sig
It is very likely that I will buy items with or without a promotion.	4.0	3.8	0.2	Yes	1.34	1.11	110.0	0.27
Sample Size	45	67			0.14
*Yes=Equal; No=Not Equal at 95% level of significance.
Error means no variance or some other data error.
H0: The mean preference for buying items with or without a promotion is equal (not different) to times you go to the store in a week.
Ha: Not equal (different)
Independent-sample t-test
t= 1.11
df= 110.0
a= .05
Do not reject H0:
\|1.11\|< 1.96
.27> .05
There is not a significant difference in the mean preferenct forbuying items with or without a promotion 0-1 (4.0) and 2-3 (3.8) on a scale of 1-5 with 1 being strongly disagree and 5 being strongly agree

CrossTabs

Crosstabulation Analysis (No table indicates an error in your data)
CROSSTABS VARIABLES ANALYZED
Row Variable ->>	In a week, how many times do you go to the store?
Column Variable ->>	Total number of children in household
Observed Frequencies
	0 to 1	2 to 3	4 or more	children	Grand Total
0 to 1	43	2	0	0	45
2 to 3	50	14	3	0	67
4 or more	7	2	1	0	10
timestostore	0	0	0	1	1
Grand Total	100	18	4	1	123
H0: There is no relationship between total amount of children in household and how many times you go to the store in a week.
Ha: "relationship"
Chi-square Test of Independence
There is no relationship

Regression

Linear Regression Analysis
Results: Least Squares Method of Regression				Statistical values
Dependent Variable	Total Cases	122		F	dfReg	dfTot	Sig	Rsq	SErrY
I feel like I am a smart shopper.				10.6	5	116	0.00	0.31	0.84
Independent Variable(s)	Coefficient	Standardized	Significant?*	t	Sig
I would patronize the promoting store.	-0.05	-0.05	No	-0.6	0.58
I feel that I am getting a good deal.	0.23	0.21	Yes	2.3	0.03
I can upgrade to a better brand.	0.14	0.12	No	1.1	0.26
I can afford a better-than-usual product.	0.18	0.15	No	1.6	0.11
I can have a higher-quality product at the same price.	0.30	0.28	Yes	2.9	0.00
Intercept	0.91		Yes	2.1	0.04
*95% level of confidence
If found, variables with zero variance are not included
Trimmed Regression Analysis Results (Backward Stepwise)				Statistical values
Dependent Variable	Total Cases	122		F	dfReg	dfTot	Sig	Rsq	SErrY
I feel like I am a smart shopper.				17.2	3	118	0.00	0.30	0.84
Independent Variable(s)	Coefficient	Standardized	Significant?*	t	Sig
I feel that I am getting a good deal.	0.25	0.23	Yes	2.8	0.01
I can afford a better-than-usual product.	0.22	0.19	Yes	2.2	0.03
I can have a higher-quality product at the same price.	0.32	0.30	Yes	3.3	0.00
Intercept	0.94		Yes	2.2	0.03
*95% level of confidence
H0: There is no relationship between feeling like a smart shopper and the independent variables.
Ha: "Relationship
Multiple Regression
F= 17.2
df= 118
a=.05
Reject H0
\|17.2\| >1.96
0.00 < .05
There is a relationship between feeling like a smart shopper and and three independent variables: (1)I feel that I am getting a good deal, (2) I can afford a better-than-usual product, (3) I can have a higher-quality product at the same price.
Probability of feeling like a smart shopper is on a scale from 0%-100%
All three independent variable products are on a scale of 1-5 with 1 = strongly disagree to 5 = very strongly agree
The baeline probability of feeling like a smart shopper is .94%
For every one unit of feeling of getting a good deal is .25%
For every one unit of affording a better-than-usual product is .22%
For every one unit of having a higher-quality product is .32%
The following independent variable does not affect the probability of feeling like a smart shopper is:'
I would patronize the promoting store.
I can upgrade to a better brand.

Corr1

Correlation Analysis Results
					Statistical Values
I can get ideas of new things to buy.	Correlation	Sample Size	Significant?*	Strength	t	df	Sig
With...
I will use a product regularly after purchasing it on sale.	0.25	122	Yes	Very weak	2.9	120	0.01
I am likely to identify a brand after purchasing it on sale.	0.23	122	Yes	Very weak	2.6	120	0.01
*Yes=significantly different from zero at 95% level of confidence. Error means no variance or some other data error.
H0: There is no relationship between getting an idea of new things to buy and (1) I will use a product regularly after purchasing it on sale. (2) I am likely to identify a brand after purchasing it on sale.
Ha: "Relationship"
Correlation
t=(1)2.9 (2) 2.6
df= 122
a= .05
Reject H0:
\|2.9\| > 1.96
\|2.6\| > 1.96
\|.01\|<.05
There is a relationship between getting an idea of new things to buy and (1) I will use a product regularly after purchasing it on sale. (2) I am likely to identify a brand after purchasing it on sale.
It is a weak positive relationship
As (1) I will use a product regularly after purchasing it on sale increases getting an idea of new things to buy also increases.
As (2) I am likely to identify a brand after purchasing it on sale increases getting a new idea of new things to buy also increases.

Data

Q1	Q2	Q3	Q4	Q5	Q6	Q7	Q8	Q9	Q10	Q11	Q12	Q13	Q14	Q15	Q16	Q17	Q18	Q19	Q20	Q21	Q22	Q23	Q24	Q25	Q26	Q27	Q28	Q29	Q30	Q31	Q32	Q33	Q34	Q35	Q36	Q37	Q38	Q39	Q40	Q41	Q42	Q43	Q44
needaproduct	lifeeasier	enjoyable	tryingnewbrands	buyingaproduct	feelgood	avoidbuying	newthingtobuy	morepromoslikethis	proud	smartshopper	hiqualityproduct	betterthanusual	upgrade	gooddeal	tryproduct	sawinastore	patronize	activelyseek	priceshown	worw/opromo	buywithorw/opromo	buynexttime	tryw/promo	advertisement	consideratpromostore	buyatpromostore	stronglikliehood	useregularly	idbrandaftersale	brandheardof	familiarwith	nobuyifnotheardof	familiarity	gender	yearofbirth	race	marital	education	salary	children	timestostore	spendonpaste	zipcode
1	2	3	3	3	3	4	4	4	4	3	4	3	5	3	4	1	2	3	3	5	4	3	5	1	3	4	3	1	2	4	3	4	4	2	2	1	2	3	1	2	2	2	93726
2	3	2	2	3	2	2	4	3	3	3	3	3	3	3	4	4	3	3	4	4	5	3	4	2	4	3	3	4	3	5	5	4	4	1	1	1	1	1	3	2	2	1	92563
5	4	4	4	5	5	3	5	4	5	5	5	4	5	5	5	5	5	4	4	4	4	4	4	4	3	4	4	4	4	4	4	3	4	2	2	1	2	3	2	1	1	2	93720
4	4	5	4	2	4	2	4	4	4	5	4	4	4	4	4	2	4	4	2	2	2	2	4	2	5	5	5	2	4	4	4	4	4	2	2	3	2	2	1	2	2	1	93722
4	2	5	4	4	3	2	3	3	4	5	4	3	4	4	4	4	2	3	4	4	4	3	4	4	4	4	5	5	4	3	4	4	5	2	2	3	2	1	1	1	2	1	93726
4	4	4	3	4	3	2	4	3	4	4	4	4	4	4	3	4	3	4	2	3	2	3	4	3	4	3	4	4	5	5	4	4	5	2	2	1	1	2	1	1	2	1	93705
3	4	4	5	5	4	4	5	5	4	5	4	4	4	5	4	3	4	5	5	3	3	4	4	4	3	4	4	5	5	5	5	4	4	2	1	1	1	3	1	1	1	1	93451
4	2	3	5	4	2	3	5	3	3	4	4	4	4	5	4	4	3	4	3	5	5	4	5	3	4	4	3	4	4	4	5	4	5	2	2	1	2	4	1	1	1	1	93612
4	4	4	5	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	2	2	1	2	1	1	1	1	1	93722
4	3	4	4	4	3	3	5	3	3	5	5	4	3	2	5	4	4	1	2	3	4	3	4	4	3	4	4	2	4	4	4	5	4	1	2	1	2	2	2	1	1	1	93291
4	5	5	3	5	4	3	4	4	5	5	5	4	5	5	5	4	3	5	5	4	2	2	5	5	5	5	5	5	5	4	5	3	2	2	2	3	2	4	1	1	3	1	93901
5	3	3	5	4	3	3	3	3	4	4	4	3	4	3	4	3	3	3	4	3	3	2	3	4	4	3	3	3	4	4	4	3	4	1	2	3	2	2	1	1	3	1	93726
4	4	5	4	4	5	4	4	3	4	2	4	4	4	3	4	4	5	4	2	4	4	4	4	4	5	4	4	4	4	3	2	4	2	2	2	1	2	3	2	1	2	2	93722
1	1	1	1	3	3	3	4	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	5	5	5	2	2	5	2	3	1	1	1	2	23553
4	4	4	4	4	4	4	5	4	4	4	4	4	4	4	5	4	4	5	4	5	5	4	4	5	4	4	4	4	5	5	5	3	5	1	2	4	1	2	1	1	2	2	93720
4	4	3	4	4	3	4	4	3	3	4	3	3	3	3	4	3	3	4	4	4	5	3	3	3	3	3	3	2	3	4	4	4	4	2	1	1	1	2	3	1	2	2	97526
4	3	2	4	3	2	3	4	1	4	4	4	4	4	3	4	4	1	2	4	4	4	2	3	2	4	3	3	4	3	4	4	4	4	2	2	5	2	1	1	1	1	1	21235
3	3	4	4	2	3	2	4	2	3	4	4	4	4	4	4	4	4	4	3	4	4	3	4	4	4	4	4	3	4	4	4	2	2	2	1	1	1	1	2	1	1	1	93532
4	3	5	2	5	4	2	4	3	4	2	2	1	3	4	4	3	2	4	4	4	5	3	3	4	4	4	3	3	3	3	4	5	5	2	2	1	2	1	1	1	1	1	93711
4	3	4	4	4	3	4	4	3	4	4	4	4	4	4	4	4	3	4	4	4	4	4	4	4	4	4	4	4	4	4	2	2	2	2	1	1	1	2	1	1	2	1	93277
2	2	3	2	2	4	2	4	2	3	3	4	4	4	4	4	3	2	2	4	4	4	2	4	2	3	2	2	4	4	4	4	4	4	2	1	1	1	1	2	2	2	1	30269
3	3	3	4	4	3	3	3	3	3	3	4	4	4	4	4	3	3	4	3	3	3	3	3	3	3	3	3	2	4	4	4	3	3	2	1	1	2	1	1	1	1	1	46118
3	3	3	4	3	3	2	4	4	3	5	2	3	3	3	4	3	3	2	3	4	4	2	3	2	3	3	3	4	4	4	4	4	4	2	1	5	2	1	1	2	2	2	94579
1	3	4	3	2	1	2	2	1	3	4	2	5	2	3	3	3	2	2	2	1	5	2	2	1	2	2	2	1	5	5	4	2	4	2	1	1	1	2	3	1	1	1	92086
4	4	4	3	3	3	4	4	4	3	4	3	5	5	4	4	3	2	3	3	2	4	3	4	3	4	4	3	2	4	5	5	4	4	1	1	1	1	2	1	1	2	1	93532
3	3	4	4	3	3	3	4	3	3	4	3	3	3	4	4	3	3	4	3	3	3	3	4	4	3	3	3	3	3	3	4	3	4	2	1	1	2	3	1	1	2	1	90036
3	4	4	4	4	3	4	5	4	5	5	3	4	4	4	4	5	3	5	5	3	4	4	4	5	5	5	4	5	5	5	4	5	3	2	1	1	2	2	1	1	1	3	93292
2	1	4	2	3	2	2	4	3	3	3	4	4	3	3	3	3	3	3	3	3	4	2	3	1	4	3	3	3	2	4	4	2	4	1	1	5	1	2	2	1	1	2	93532
4	2	2	4	3	1	5	5	2	3	4	4	3	4	4	4	4	3	2	4	3	5	4	4	2	3	3	3	3	3	4	4	4	4	2	1	1	2	3	1	1	1	1	93532
3	4	2	1	2	4	4	2	2	3	4	4	4	3	4	3	3	1	2	4	2	4	3	4	1	4	3	4	3	3	4	4	2	3	2	1	1	1	4	2	1	1	2	93532
1	3	4	2	4	2	2	2	2	2	4	1	4	3	4	3	3	2	3	4	2	2	2	4	4	2	1	1	3	3	4	4	2	4	1	2	1	1	2	1	1	3	1	93726
3	4	2	2	4	1	3	4	3	3	4	4	4	4	4	4	5	3	2	4	3	3	2	4	2	4	3	3	1	4	5	5	4	4	2	1	1	1	3	2	1	2	2	91390
3	3	4	4	4	3	3	4	3	3	5	4	3	3	3	3	5	3	2	3	3	4	3	4	4	3	3	3	3	4	4	3	3	4	1	2	3	2	1	1	1	1	1	95370
3	4	4	5	3	4	3	4	3	4	4	4	3	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	3	4	4	4	3	4	2	1	5	2	2	1	1	2	1	93532
4	3	3	4	4	3	3	4	2	4	4	4	4	4	4	4	4	3	4	4	4	5	3	2	2	3	3	3	2	4	4	2	2	4	2	2	3	2	4	1	1	2	1	93274
5	4	4	5	4	3	5	5	4	4	2	4	3	3	4	4	4	3	5	4	3	4	4	3	4	5	4	4	2	2	5	5	2	3	2	2	3	2	1	1	2	2	1	93727
2	2	2	5	2	2	4	4	3	3	4	5	4	5	2	2	4	2	1	4	2	5	2	1	1	2	4	2	1	5	5	5	2	4	2	2	3	2	2	1	1	2	1	93702
3	2	2	3	4	2	3	4	1	3	4	3	3	4	3	3	3	3	4	4	3	5	2	4	2	4	3	2	3	4	4	4	1	3	1	1	1	1	2	1	1	2	1	93532
3	2	4	4	4	4	5	4	3	4	5	4	4	3	4	4	5	3	5	3	4	4	4	5	5	4	4	4	3	5	5	4	3	4	2	2	5	1	3	2	1	1	1	93711
3	4	4	4	4	3	2	4	3	4	4	4	5	5	3	4	2	3	4	4	4	5	4	3	2	4	4	3	2	4	4	5	5	5	2	2	5	2	2	2	1	2	1	93611
5	1	2	4	3	3	4	4	2	3	4	4	4	4	3	3	3	3	1	3	4	4	3	3	1	3	3	4	2	3	3	2	1	2	1	2	5	2	1	1	2	2	2	93291
5	4	5	2	3	3	2	5	3	4	4	5	2	3	3	4	3	3	3	2	2	4	3	4	4	3	4	3	2	4	4	5	4	5	2	2	1	2	3	1	1	2	1	93274
5	4	5	4	5	5	2	5	5	5	5	5	5	4	5	5	4	5	5	5	3	4	4	5	4	5	5	5	5	5	5	5	3	5	2	1	1	1	2	1	1	2	1	93532
4	3	4	3	4	4	4	4	3	4	3	3	4	4	3	4	3	3	4	4	2	4	3	4	4	4	4	4	3	4	4	3	2	2	1	1	1	1	3	1	1	1	1	84067
4	1	3	4	3	3	2	4	2	4	5	4	4	4	4	3	4	3	2	2	4	4	1	1	2	3	2	2	4	4	4	4	2	4	1	2	1	2	1	1	2	2	2	92704
4	3	3	1	2	3	1	4	3	3	5	5	4	3	3	4	4	2	4	4	4	4	2	4	4	4	3	3	2	2	4	5	5	5	2	2	1	1	3	2	1	1	1	93291
4	4	3	3	2	4	2	4	3	4	3	4	4	4	3	4	4	3	4	4	4	4	3	4	3	4	4	3	2	4	4	4	3	4	1	2	3	2	4	1	1	2	2	90813
4	3	4	2	4	4	2	2	3	2	4	4	4	4	4	2	4	4	4	4	2	2	2	2	2	4	4	4	4	4	4	4	4	4	1	2	1	1	2	3	1	2	2	90404
3	3	4	4	3	4	5	3	4	3	4	3	3	3	5	4	3	3	4	4	3	3	3	2	3	3	3	3	3	3	3	3	4	4	1	2	1	2	1	1	1	2	2	93274
3	1	4	4	4	3	1	3	3	3	4	3	5	3	3	3	3	4	3	3	2	2	3	3	2	4	4	3	2	4	4	4	4	3	1	2	1	2	1	2	1	1	1	98108
4	3	3	4	4	4	4	4	3	4	5	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	2	1	1	1	2	2	3	2	2	93230
4	4	3	4	1	2	5	4	3	4	4	3	4	4	4	5	3	4	4	2	2	2	4	4	1	4	4	4	3	5	5	2	5	1	2	1	1	1	2	1	1	1	1	93532
3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	1	1	1	1	1	1	1	2	2	93291
2	1	1	3	3	3	3	3	1	1	1	3	3	3	3	2	4	4	4	4	4	3	4	2	1	3	3	3	4	4	1	1	3	3	2	1	1	1	2	1	2	2	1	97219
4	4	4	2	4	2	1	4	3	3	4	4	4	4	4	4	4	3	4	4	5	5	5	4	3	4	4	4	5	4	5	5	2	4	2	1	1	1	2	1	1	1	1	93532
3	3	3	1	4	5	1	5	4	4	5	5	4	5	2	5	1	3	4	2	5	3	3	3	4	4	4	3	4	3	4	3	4	4	2	2	3	2	1	1	3	3	2	93604
4	5	5	3	5	5	3	5	5	4	4	5	4	5	4	4	4	3	4	4	4	5	4	4	4	4	3	3	2	4	4	5	2	3	2	2	1	1	1	2	1	2	1	90638
3	3	2	2	3	4	4	3	3	3	2	3	2	1	3	2	1	2	3	3	1	1	3	3	2	2	3	3	3	3	2	2	3	3	1	1	1	1	1	1	2	3	3	93292
3	3	3	2	2	1	2	5	3	3	4	3	3	3	2	2	4	4	4	3	4	5	3	2	4	4	3	1	2	4	4	4	2	4	1	2	3	2	3	1	1	1	1	94521
2	3	3	4	3	1	1	4	3	3	4	3	3	3	4	3	3	2	4	3	2	4	3	4	3	4	3	3	2	4	4	5	3	5	2	1	1	1	2	1	1	2	1	77080
2	1	4	1	1	3	1	3	3	3	1	1	4	3	3	1	1	3	1	3	5	5	1	1	3	4	3	3	5	3	5	3	3	3	2	2	3	2	3	1	1	3	2	95404
3	4	3	5	2	3	4	5	3	3	3	4	4	4	3	4	3	1	3	3	3	4	3	5	2	3	3	3	2	4	3	4	2	3	1	1	1	1	2	1	2	2	1	93726
2	2	2	4	3	2	2	4	2	2	4	4	4	4	3	4	4	2	3	4	4	4	3	4	2	4	4	4	3	4	4	4	2	2	1	2	1	2	4	1	1	2	1	93711
2	2	1	3	3	3	3	3	3	3	2	2	2	2	2	2	2	2	2	3	2	2	2	3	3	2	2	3	3	3	4	4	4	3	1	1	1	1	3	3	2	2	2	91390
3	4	5	3	4	5	4	4	4	4	5	5	5	5	5	5	4	4	5	3	2	5	5	5	4	4	4	4	3	4	4	4	2	1	2	2	5	1	4	3	2	1	1	93532
2	2	2	4	4	3	2	4	2	4	4	5	5	5	4	4	5	4	4	4	5	5	3	4	2	5	4	4	3	3	5	4	2	3	2	1	1	1	2	3	1	2	2	93532
5	4	5	5	4	4	4	5	5	5	5	5	5	5	4	4	5	4	5	5	4	4	5	5	5	5	5	5	1	5	4	4	2	2	2	1	1	1	2	1	2	2	3	98499
2	1	2	3	2	3	4	5	1	4	2	3	4	4	4	3	3	3	4	5	5	5	3	4	4	3	4	5	4	2	1	5	5	4	2	1	1	1	4	1	2	2	2	93532
4	4	4	5	5	3	2	4	3	4	4	4	4	3	3	5	4	3	3	4	5	5	2	4	4	4	4	4	5	4	3	5	5	5	2	2	3	2	1	1	1	2	2	93726
4	2	4	4	5	4	4	5	4	5	5	5	5	5	4	4	4	4	4	4	2	5	5	5	5	4	4	5	5	5	5	5	2	2	2	1	3	2	3	1	1	1	2	93532
2	4	3	2	2	1	3	4	3	3	5	5	4	4	4	4	2	2	2	4	4	4	4	5	4	4	4	4	4	3	5	5	5	5	1	2	4	2	2	1	1	2	1	93722
3	4	4	3	4	3	3	3	3	3	3	4	4	4	4	3	3	3	3	3	3	3	3	3	3	2	3	3	3	4	3	3	3	4	2	1	1	1	1	3	1	2	3	93532
4	4	4	2	5	2	1	4	3	5	4	5	4	3	4	3	4	1	3	4	2	4	4	5	5	4	4	4	3	4	5	5	2	4	2	2	3	2	1	1	1	2	1	93286
3	4	4	5	4	3	4	5	3	3	4	4	4	3	3	3	3	3	3	2	4	4	3	4	4	4	3	2	4	4	4	4	2	4	2	2	3	2	3	1	1	2	2	93701
3	3	4	2	2	1	2	4	4	3	5	5	5	5	3	3	5	3	4	3	4	2	4	4	4	4	3	4	2	4	4	4	5	5	1	2	3	2	3	1	1	2	1	93726
3	4	4	4	2	3	3	4	2	4	1	3	3	3	2	4	3	3	3	3	3	3	3	3	3	3	3	3	4	2	2	2	4	4	2	2	2	2	2	1	1	2	1	93710
4	4	3	2	4	3	3	4	3	3	5	4	4	4	4	4	2	3	2	2	4	5	2	4	3	3	3	2	2	4	4	4	3	4	2	2	5	1	3	1	1	1	1	93362
2	3	4	4	4	3	2	4	3	4	4	3	4	4	4	4	3	3	3	4	4	4	4	4	4	4	3	3	4	4	4	4	2	2	1	2	4	2	2	1	1	1	2	93727
3	4	4	3	1	1	5	3	3	4	4	3	4	5	3	4	4	3	2	3	4	5	2	4	3	4	3	3	1	4	5	4	2	2	1	2	3	2	1	1	1	1	1	93711
3	3	4	4	4	3	3	4	4	4	4	4	4	2	4	4	3	3	3	4	4	4	4	4	2	3	3	3	2	4	4	4	5	5	2	2	4	2	2	1	3	2	1	93727
2	1	5	4	3	3	3	3	3	5	4	5	3	4	4	5	4	4	4	5	5	3	3	5	4	4	3	4	4	4	4	3	2	3	1	2	5	2	2	1	1	2	1	93612
3	3	2	2	3	2	2	4	4	4	3	3	3	4	3	4	4	2	2	4	4	4	4	5	2	3	3	3	3	3	4	4	2	4	2	2	4	2	1	1	3	2	2	93726
3	4	4	3	4	4	4	4	3	4	5	4	4	4	3	4	4	4	4	3	4	4	4	4	4	4	4	4	5	4	4	4	3	4	1	2	2	2	1	1	1	2	2	90059
5	3	4	4	5	4	1	3	4	4	2	4	4	2	4	4	4	2	4	2	4	4	4	5	4	4	4	3	2	4	4	5	5	5	1	2	4	2	2	1	1	2	1	93662
4	4	4	2	5	4	3	4	5	4	2	4	4	4	4	3	4	5	4	3	2	3	3	4	4	4	4	4	4	4	4	4	4	4	1	2	4	2	2	1	1	1	3	93630
5	5	5	1	5	5	1	4	4	5	5	5	5	4	5	4	5	5	5	5	4	4	3	4	4	4	4	4	4	4	5	5	2	4	2	2	3	2	1	1	2	1	2	93727
4	3	5	5	5	5	2	4	3	4	4	2	2	4	5	5	4	2	2	4	4	4	4	4	4	4	4	4	4	4	5	5	2	4	2	2	3	2	1	1	1	2	3	93703
4	3	4	3	3	3	5	4	3	5	4	4	4	4	4	4	4	1	3	3	3	5	3	4	4	5	2	3	5	4	5	4	2	4	1	2	3	2	3	1	1	1	1	93726
4	3	3	3	2	3	2	4	3	4	4	4	3	3	4	2	3	2	3	3	3	4	3	4	3	3	3	3	2	4	4	4	3	4	2	2	3	2	1	1	1	1	1	93727
2	2	2	4	2	3	1	4	1	3	3	4	4	4	3	1	3	3	2	4	4	4	2	2	1	1	1	1	3	4	2	2	2	2	2	2	4	2	1	1	1	1	3	93726
2	2	4	4	2	2	1	4	3	3	5	3	3	3	3	4	2	3	2	2	3	3	3	2	2	3	3	3	3	4	3	1	1	3	2	2	1	2	2	1	1	1	1	93612
1	3	2	2	2	2	3	4	2	3	3	3	3	2	3	2	3	2	3	3	3	4	2	3	3	3	3	3	4	4	3	4	3	4	2	1	1	2	2	2	1	1	2	93003
5	2	2	1	1	5	1	1	1	4	5	5	4	3	5	1	2	1	1	2	2	4	1	1	4	1	2	3	2	4	5	5	5	5	2	2	2	2	1	1	1	2	1	93726
3	3	4	4	4	4	2	4	3	4	4	3	3	3	4	4	4	3	4	2	3	4	3	4	3	4	3	3	3	4	4	5	3	5	2	2	1	2	2	1	1	1	1	93035
4	4	4	2	2	2	2	4	3	3	4	4	4	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	1	1	2	5	4	5	2	1	1	1	1	3	1	3	2	93001
3	4	4	4	4	4	2	4	4	5	3	4	3	4	3	5	3	3	3	3	2	4	4	3	2	3	3	3	3	4	5	3	4	4	2	1	2	2	1	1	1	2	2	93004
4	3	4	4	4	4	2	4	4	4	4	2	4	4	4	4	3	3	4	4	2	4	4	4	3	3	3	4	2	4	5	3	2	4	2	2	3	2	3	1	1	2	1	93727
4	3	4	4	2	3	2	4	3	3	3	3	4	4	4	4	3	4	1	2	3	4	2	4	2	4	4	4	3	4	4	4	2	4	2	1	1	1	2	2	1	2	2	93720
2	3	4	2	2	3	4	3	3	3	4	3	4	4	3	3	3	3	3	3	3	3	3	3	3	3	3	3	2	2	4	4	3	3	2	2	4	2	1	1	1	2	1	93291
5	4	3	5	4	4	5	4	3	3	5	5	5	5	4	4	4	3	2	3	1	4	3	4	4	3	4	4	4	5	4	4	5	5	2	1	1	1	1	2	1	1	2	93532
3	3	4	1	1	1	3	3	1	3	5	3	2	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	3	2	2	1	1	3	2	1	1	1	91505
2	1	2	1	2	1	2	1	2	1	2	1	2	1	1	2	2	1	2	1	2	1	2	1	2	1	2	1	1	2	1	2	1	2	1	2	1	2	1	1	1	2	2	93532
4	3	4	4	4	4	3	5	3	3	4	4	1	3	4	4	4	4	4	4	4	4	2	4	4	4	4	4	5	3	4	4	2	2	2	1	1	1	1	2	1	2	1	93532
1	2	1	1	1	1	5	1	1	1	1	1	1	1	1	1	5	1	1	1	5	5	1	5	1	1	1	1	1	1	1	5	5	5	1	2	1	2	2	2	1	2	2	84604
4	4	4	4	4	3	3	4	3	3	4	4	4	4	4	4	3	3	3	3	3	4	3	2	2	3	3	3	3	4	4	4	2	2	2	1	1	2	4	1	1	1	1	93274
4	3	2	1	2	2	3	4	2	1	4	3	3	3	3	2	2	2	2	3	2	3	2	3	2	3	3	3	3	2	4	4	2	4	2	1	1	1	3	2	1	1	1	91390
1	1	1	2	1	1	4	4	1	3	4	3	4	4	3	4	3	3	3	4	3	4	3	4	1	4	4	3	3	4	4	4	1	2	2	1	1	2	2	1	1	3	1	97459
2	4	3	1	4	3	4	4	3	4	4	4	4	4	4	4	4	4	4	4	2	3	4	4	5	4	4	4	4	4	4	4	4	4	1	2	5	2	2	1	1	2	1	93010
4	4	3	5	4	4	3	3	3	3	5	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	1	4	4	5	3	5	2	1	1	1	1	1	1	1	1	93532
1	1	1	3	1	1	3	4	1	3	3	4	4	3	3	2	2	1	1	1	3	4	3	2	1	1	1	1	3	2	2	3	3	3	1	2	4	2	1	1	1	1	1	93710
4	4	5	5	3	3	3	4	3	3	3	4	4	3	4	4	4	4	4	4	2	2	4	4	2	4	4	3	3	4	4	4	2	3	2	1	1	1	2	1	1	2	2	93033
4	2	4	2	4	3	4	4	2	3	4	4	4	4	4	4	4	4	4	4	2	2	2	4	4	4	4	4	2	4	4	5	4	4	2	1	1	2	2	2	1	1	1	93550
4	4	4	4	4	3	4	4	3	4	4	4	4	3	4	4	3	4	4	2	2	2	2	4	4	4	4	4	3	3	3	4	2	4	1	2	1	2	2	1	1	2	1	77095
4	4	4	5	5	4	2	4	4	5	4	4	4	3	4	4	4	4	3	2	3	4	3	5	5	4	4	4	4	4	5	5	3	5	2	2	4	2	2	1	1	2	2	93292
4	2	4	4	4	4	5	5	5	4	4	5	5	5	4	5	4	4	4	5	4	4	3	4	4	3	3	4	4	3	4	4	3	3	2	1	1	1	4	2	1	2	1	91205
4	3	4	3	4	4	2	5	3	5	4	4	3	4	3	4	5	5	4	4	5	5	4	4	5	3	3	4	5	5	3	5	5	5	2	1	1	1	2	2	1	2	3	93532
4	4	4	4	4	4	3	4	4	4	5	4	5	5	5	5	4	4	4	4	4	4	4	4	4	4	4	4	2	4	3	4	2	3	2	1	1	1	2	2	1	1	1	99006
3	4	4	3	5	4	2	4	4	4	4	4	3	4	4	4	4	1	4	4	3	2	4	4	4	4	4	5	4	4	3	4	4	4	2	2	3	2	1	3	1	2	1	93256
2	3	3	2	4	4	1	3	3	4	5	4	4	4	4	4	4	3	3	3	4	4	3	4	3	4	4	4	4	4	4	5	4	4	2	1	3	2	2	1	1	3	1	91390
4	3	4	4	4	4	4	4	4	4	4	5	4	4	4	4	4	3	4	3	4	4	3	3	4	4	4	4	3	4	4	5	3	5	2	2	1	1	2	2	2	2	3	93532
4	3	3	4	4	3	5	4	3	3	4	4	2	4	3	3	4	2	3	4	3	5	1	3	3	3	3	4	2	4	4	3	1	1	2	2	5	1	4	1	2	3	1	93532
4	4	3	2	3	3	2	2	3	4	5	3	4	4	3	3	3	2	3	4	3	4	3	4	4	4	4	4	4	4	5	5	4	5	1	2	3	2	1	1	1	1	2	93727

Define Variables

Variable Label
alburns: Variable Labels - Copy labels from Row 1 of your Data Worksheet. Place your cursor in cell B1 of this worksheet and Paste Special-Paste Link to link Define Variables information to the Data set.

Q10

Q11

Q12

Q13

Q14

Q15

Q16

Q17

Q18

Q19

Q20

Q21

Q22

Q23

Q24

Q25

Q26

Q27

Q28

Q29

Q30

Q31

Q32

Q33

Q34

Q35

Q36

Q37

Q38

Q39

Q40

Q41

Q42

Q43

Q44

Description
alburns: Description - Type or Paste in a long Description under each Variable Label.

Promotions remind me that I need a product.

Promotions make my life easier.

Promotions are enjoyable.

I like trying new brands.

Promotions make me feel like buying a product.

Promotions make me feel good.

I can avoid buying the same brands.

I can get ideas of new things to buy.

I wish there were more promotions like this.

I can be proud of my purchase.

I feel like I am a smart shopper.

I can have a higher-quality product at the same price.

I can afford a better-than-usual product.

I can upgrade to a better brand.

I would try the promoted product.

I feel that I am getting a good deal.

I would buy the product if I saw it in a store.

I would patronize the promoting store.

I would actively seek out the promoted product in a store.

I would buy the product at the price shown.

I would purchase the promoted product with or without a promotion.

It is very likely that I will buy items with or without a promotion.

I will purchase a promoted brand the next time I need an item.

I will try a product if there is a promotion.

I am eager to check out a product based on an advertisement.

I would consider buying a promoted product at the promoting store.

I will purchase a product at the promoting store.

There is a strong likelihood that I will buy a product at the promoting store.

I will use a product regularly after purchasing it on sale.

I am likely to identify a brand after purchasing it on sale.

I will buy a product from a brand I have heard of.

I purchase products based on brands I am familiar with.

I will not purchase a product if I have never heard of the brand.

Buying brands I am familiar with is important to me.

My gender is

Year of my birth is

Race or ethnic identity

Marital status

What is your highest educational level?

My current annual salary/income is

Total number of children in household

In a week, how many times do you go to the store?

On average, how much did you spend on toothpaste in the past month?

What is your zip code?

Value Codes
alburns: Value Codes - Type in your value code numbers, separated by commas in the cells under the Variable Descriptions.

1,2,3,4,5

1,2

1,2,3

1,2,3,4,5,6

0,1

1,2,3,4

1,2,3

Value Labels
alburns: Value Labels - Type in the labels associated with your value codes, in order and separated by commas in the cells under the value codes.

Strongly disagree,Disagree,Neither disagree nor agree,Agree,Strongly Agree

Female,Male

1950 to 1974,1975 to 1999,2000 and after

Caucasian,Black/African American,Native American,Hispanic/Latino(a),Asian/Pacific Islander,Other

Married,Not Married

High School,College Graduate,Higher Education,Other

Under $50k,$50k to $99k,$100k and more

0 to 1,2 to 3,4 or more

$0 to $5,$6 to $10,$11 to $15

To set up your data… (Note: if you have a csv file, 1-3 is accomplished with Utilities-Import Data)

1. Copy Labels from Row 1 of your Data worksheet.

2. Place your cursor in cell B1 of the Define Variables worksheet.

3. Paste Special-Paste Link to link your Variables information to the Data worksheet

Then,

4. Type in Descriptions. They can be as long as you wish.

5. Type in Value Codes separated by commas

6. Type in Value Labels separated by commas

7. Use Utilities-Clean-up to check your Value Code-Value Labels work

FRIENDLY

CIRCLEK

COMMUTE

BARGAIN

CASH

QUICK

KNOWME

HURRY

DWELL

GENDER

WORK

PieTemp

Percentages Analysis Results
	title of graph
	Category	Frequency	Percent
	Category 1	100	10.0%
	Category 2	432	43.2%
	Category 3	210	21.0%
	Category 4	258	25.8%
	Total	1000	100.0%

Category 1 Category 2 Category 3 Category 4 0.1 0.432 0.21 0.25800000000000001

CylinderTemp

Percentages Analysis Results
	Title of graph
	Category	Frequency	Percent
	Category 1	100	10.0%
	Category 2	432	43.2%
	Category 3	210	21.0%
	Category 4	258	25.8%
	Total	1000	100.0%

Category 1 Category 2 Category 3 Category 4 0.1 0.432 0.21 0.25800000000000001