Uploaded The Assignment

Question

Shakeel · Accepted Answer

HW3_Data1
	Post ID	Photo	Video	Promotion	Link	Ads	plink	vlink	Views	Likes
	1	1	0	1	0	1	0	0	7406	170
	2	1	0	0	0	1	0	0	6680	156
	3	1	0	1	0	1	0	0	6439	136
	4	1	0	1	0	0	0	0	6607	172
	5	1	0	1	1	0	1	0	5835	139
	6	1	0	1	1	0	1	0	6159	155
	7	1	0	0	0	0	0	0	5616	142
	8	1	0	0	0	0	0	0	5630	147
	9	1	0	0	1	0	1	0	5589	152
	10	1	0	1	0	0	0	0	6038	147
	11	1	0	0	1	0	1	0	6073	164
	12	1	0	1	0	0	0	0	5509	130
	13	1	0	0	1	0	1	0	5532	160
	14	1	0	1	1	0	1	0	7028	171
	15	1	0	0	1	0	1	0	5678	153
	16	1	0	1	0	0	0	0	6509	157
	17	1	0	1	0	0	0	0	6593	153
	18	1	0	1	0	0	0	0	6134	142
	19	1	0	0	0	0	0	0	5452	152
	20	1	0	0	1	0	1	0	5462	139
	21	1	0	0	1	0	1	0	6562	174
	22	1	0	0	1	0	1	0	5289	153
	23	1	0	0	0	1	0	0	6088	143
	24	1	0	0	1	1	1	0	6451	163
	25	1	0	0	0	0	0	0	5240	135
	26	1	0	0	1	0	1	0	5956	168
	27	1	0	1	1	0	1	0	6705	166
	28	1	0	1	1	0	1	0	7156	165
	29	1	0	1	0	0	0	0	6177	155
	30	1	0	0	0	0	0	0	5551	149
	31	1	0	0	0	0	0	0	5513	139
	32	1	0	1	0	1	0	0	6541	146
	33	1	0	0	0	0	0	0	6830	174
	34	1	0	0	1	0	1	0	6318	168
	35	1	0	0	0	0	0	0	5847	139
	36	1	0	1	1	0	1	0	7792	196
	37	1	0	0	0	1	0	0	7020	173
	38	1	0	1	1	0	1	0	7403	174
	39	1	0	0	0	0	0	0	5557	146
	40	1	0	1	1	0	1	0	7576	188
	41	1	0	0	1	0	1	0	6860	170
	42	1	0	0	0	0	0	0	6075	164
	43	1	0	1	0	0	0	0	4553	107
	44	1	0	0	0	0	0	0	5922	162
	45	1	0	1	0	0	0	0	5739	148
	46	1	0	1	0	0	0	0	6119	161
	47	1	0	1	1	1	1	0	6317	143
	48	1	0	0	0	0	0	0	5540	156
	49	1	0	0	1	0	1	0	6409	172
	50	1	0	0	0	0	0	0	5917	160
	51	1	0	0	0	0	0	0	4731	118
	52	1	0	0	0	0	0	0	5659	152
	53	1	0	0	0	0	0	0	5369	151
	54	1	0	0	0	0	0	0	5565	158
	55	1	0	0	1	1	1	0	7137	176
	56	1	0	1	1	0	1	0	6040	141
	57	1	0	1	0	0	0	0	5312	129
	58	1	0	1	0	0	0	0	6059	158
	59	1	0	0	1	0	1	0	5443	150
	60	0	1	0	0	1	0	0	2987	64
	61	1	0	0	1	1	1	0	7428	177
	62	1	0	0	0	1	0	0	5850	133
	63	0	1	1	1	1	0	1	5062	105
	64	1	0	0	1	0	1	0	6555	170
	65	1	0	0	1	0	1	0	4875	136
	66	1	0	0	0	0	0	0	5939	155
	67	1	0	1	0	0	0	0	7799	191
	68	0	1	0	0	0	0	0	2033	64
	69	1	0	1	0	0	0	0	6623	176
	70	1	0	0	1	0	1	0	6204	162
	71	1	0	1	1	0	1	0	6928	175
	72	1	0	0	1	0	1	0	5528	145
	73	0	1	1	0	0	0	0	3254	78
	74	1	0	1	1	0	1	0	7468	171
	75	1	0	1	0	0	0	0	6357	159
	76	1	0	0	1	0	1	0	6721	176
	77	1	0	0	1	0	1	0	5064	137
	78	1	0	0	1	0	1	0	7286	184
	79	0	1	0	0	0	0	0	2104	65
	80	1	0	0	0	0	0	0	5563	150
	81	1	0	0	0	0	0	0	5920	162
	82	1	0	0	0	0	0	0	6873	180
	83	1	0	0	0	1	0	0	6329	157
	84	1	0	1	1	1	1	0	8915	185
	85	1	0	1	0	0	0	0	6605	166
	86	1	0	1	1	0	1	0	6733	165
	87	1	0	0	0	0	0	0	5629	157
	88	1	0	0	1	0	1	0	5406	144
	89	1	0	1	0	0	0	0	5886	136
	90	1	0	0	1	0	1	0	6046	144
	91	1	0	0	1	0	1	0	4704	124
	92	1	0	0	0	1	0	0	6362	162
	93	1	0	1	0	0	0	0	5562	145
	94	1	0	0	0	0	0	0	5639	151
	95	1	0	1	0	0	0	0	5355	131
	96	0	1	0	0	0	0	0	2604	75
	97	1	0	1	1	1	1	0	7196	163
	98	1	0	0	0	0	0	0	5146	140
	99	1	0	0	1	0	1	0	6338	161
	100	1	0	1	0	0	0	0	5905	143
	101	1	0	0	0	0	0	0	5172	147
	102	1	0	1	0	0	0	0	6312	157
	103	1	0	0	0	0	0	0	4549	124
	104	0	1	1	0	0	0	0	3166	77
	105	1	0	1	1	0	1	0	6520	160
	106	1	0	1	1	0	1	0	7339	171
	107	0	1	1	0	1	0	0	4834	98
	108	1	0	0	0	0	0	0	5243	140
	109	1	0	0	1	0	1	0	7129	181
	110	0	1	0	0	0	0	0	2620	75
	111	1	0	1	1	0	1	0	6766	152
	112	1	0	0	0	0	0	0	5795	155
	113	0	1	1	1	0	0	1	3934	91
	114	1	0	0	1	0	1	0	5058	138
	115	1	0	1	1	1	1	0	7947	172
	116	0	1	0	0	0	0	0	2364	70
	117	1	0	1	0	0	0	0	6236	156
	118	1	0	1	0	0	0	0	6336	157
	119	1	0	1	0	0	0	0	6399	149
	120	1	0	0	1	1	1	0	6742	162
	121	0	1	0	1	1	0	1	4538	98
	122	0	1	0	1	1	0	1	4035	91
	123	0	1	0	0	1	0	0	3122	73
	124	0	1	0	1	0	0	1	2336	70
	125	0	1	0	0	0	0	0	2515	73
	126	0	1	0	1	0	0	1	3021	83
	127	0	1	0	1	0	0	1	3305	89
	128	0	1	1	1	0	0	1	3262	78
	129	0	1	1	0	0	0	0	3132	76
	130	0	1	1	0	0	0	0	3354	82
	131	0	1	0	0	0	0	0	3143	86
	132	0	1	0	0	0	0	0	2890	81
	133	0	1	1	0	0	0	0	2791	69
	134	0	1	0	1	0	0	1	2487	73
	135	0	1	0	0	0	0	0	2492	73
	136	0	1	0	1	0	0	1	3800	99
	137	1	0	1	0	0	0	0	5520	142
	138	1	0	0	1	0	1	0	6388	172
	139	1	0	1	0	0	0	0	6840	172
	140	1	0	0	1	0	1	0	6425	170
	141	1	0	1	1	0	1	0	6426	155
	142	1	0	0	0	0	0	0	6542	184
	143	1	0	0	0	1	0	0	6297	153
	144	1	0	1	0	1	0	0	7610	179
	145	1	0	0	0	0	0	0	4693	133
	146	1	0	1	0	0	0	0	6382	158
	147	1	0	1	1	0	1	0	5711	148
	148	1	0	1	0	0	0	0	5081	122
	149	1	0	0	1	0	1	0	5339	146
	150	1	0	0	0	0	0	0	5325	146
	151	1	0	0	0	0	0	0	5752	153
	152	1	0	0	0	1	0	0	6471	157
	153	1	0	0	0	0	0	0	5482	157
	154	1	0	0	0	0	0	0	5128	137
	155	1	0	0	1	0	1	0	6308	170
	156	1	0	0	1	0	1	0	5941	163
	157	1	0	1	0	1	0	0	6637	141
	158	1	0	1	0	0	0	0	5312	134
	159	1	0	1	1	0	1	0	6014	144
	160	1	0	0	0	0	0	0	5990	158
	161	1	0	0	1	0	1	0	4984	130
	162	1	0	0	0	0	0	0	5617	155
	163	1	0	0	1	0	1	0	6118	163
	164	0	1	1	1	0	0	1	3132	75
	165	0	0	0	1	0	0	0	3335	90
	166	0	1	0	0	0	0	0	3951	102
	167	0	1	0	0	1	0	0	5149	117
	168	0	0	1	0	0	0	0	3980	94
	169	0	1	0	0	0	0	0	3566	94
	170	0	1	1	1	0	0	1	2956	72
	171	0	1	0	1	0	0	1	2498	73
	172	0	1	1	1	0	0	1	4356	100
	173	0	1	0	0	0	0	0	2374	70
	174	0	1	1	1	0	0	1	2204	56
	175	0	0	1	0	1	0	0	4815	104
	176	0	1	1	1	0	0	1	3384	79
	177	0	1	0	1	0	0	1	2234	68
	178	0	1	0	1	0	0	1	3892	101
	179	0	1	0	0	0	0	0	1794	59
	180	0	1	0	0	1	0	0	3162	74
	181	0	0	1	0	0	0	0	3722	88
	182	0	1	0	0	0	0	0	2176	67
	183	0	1	0	0	0	0	0	2608	75
	184	0	0	0	1	0	0	0	2802	79
	185	0	1	1	0	0	0	0	3394	82
	186	0	1	0	1	0	0	1	2074	64
	187	0	1	1	0	0	0	0	3190	77
	188	0	1	0	1	1	0	1	4249	98
	189	0	1	1	0	0	0	0	3401	82
	190	0	1	0	1	0	0	1	3614	95
	191	0	1	1	1	0	0	1	3064	73
	192	0	1	1	0	0	0	0	3700	87
	193	0	1	1	0	1	0	0	4228	83
	194	0	0	0	0	1	0	0	4581	104
	195	0	1	0	0	1	0	0	4018	90
	196	0	1	1	0	0	0	0	3284	74
	197	0	1	0	1	0	0	1	3578	95
	198	0	1	1	0	0	0	0	3323	80
	199	0	1	1	1	0	0	1	5128	116
	200	0	1	1	0	0	0	0	2926	72
	201	0	1	1	0	0	0	0	3369	80
	202	0	1	0	0	0	0	0	3228	88
	203	0	0	0	0	0	0	0	3522	93
	204	0	0	0	0	0	0	0	4462	112
	205	0	0	1	1	0	0	0	4918	114
	206	0	1	0	1	0	0	1	4145	106
	207	0	1	1	0	0	0	0	4467	105
	208	0	1	0	0	1	0	0	4077	88
	209	0	0	1	1	0	0	0	4833	109
	210	0	0	0	0	0	0	0	3445	92
	211	0	1	1	1	0	0	1	3572	84
	212	0	1	1	0	1	0	0	3935	75
	213	0	1	1	1	1	0	1	5269	108
	214	0	1	0	1	1	0	1	5321	121
	215	0	0	0	1	0	0	0	4162	106
	216	0	1	0	0	0	0	0	3067	84
	217	0	1	0	0	0	0	0	2825	79
	218	0	1	0	0	0	0	0	2601	75
	219	0	1	0	0	0	0	0	3926	102
	220	0	1	0	1	0	0	1	2925	82
	221	0	0	0	1	0	0	0	3428	92
	222	0	1	1	1	0	0	1	3275	76
	223	0	1	1	0	0	0	0	3363	81
	224	0	1	1	1	0	0	1	3609	84
	225	0	1	0	0	0	0	0	1833	60
	226	0	1	0	1	0	0	1	2546	74
	227	0	1	1	1	0	0	1	1865	46
	228	0	1	0	1	0	0	1	3254	88
	229	0	0	0	0	0	0	0	3319	89
	230	0	0	0	0	0	0	0	3160	86
	231	0	0	1	0	0	0	0	3866	89
	232	0	0	0	0	0	0	0	3750	98
	233	0	0	1	0	0	0	0	3943	92
	234	0	0	0	1	1	0	0	4281	101
	235	0	0	1	0	1	0	0	5145	104
	236	0	1	0	1	0	0	1	3320	89
	237	0	1	0	0	0	0	0	2583	75
	238	0	1	1	1	0	0	1	3727	89
	239	0	1	0	0	0	0	0	1567	54
	240	0	1	1	1	0	0	1	3482	85
	241	0	1	1	1	0	0	1	4068	93
	242	0	0	1	0	0	0	0	3274	78
	243	0	0	0	0	1	0	0	5101	113
	244	0	0	0	0	0	0	0	3408	91
	245	0	0	0	0	0	0	0	3469	92
	246	0	1	0	0	0	0	0	2705	77
	247	0	1	0	1	0	0	1	2335	70
	248	0	1	0	0	1	0	0	2756	62
	249	0	1	0	1	0	0	1	3149	86
	250	0	1	0	0	0	0	0	2593	75
	251	0	1	1	0	0	0	0	2930	72
	252	0	0	1	0	0	0	0	3701	87
	253	0	0	1	0	0	0	0	3708	87
	254	0	0	0	0	0	0	0	2736	78
	255	0	0	0	1	0	0	0	3823	99
	256	0	0	0	1	0	0	0	3022	83
	257	0	0	0	0	0	0	0	4850	120
	258	0	0	1	0	1	0	0	5070	107
	259	0	0	0	1	0	0	0	5012	123
	260	0	0	0	0	0	0	0	3866	100
	261	0	0	0	1	0	0	0	3617	95
	262	0	0	1	0	0	0	0	4204	101
	263	0	0	0	1	0	0	0	3270	88
	264	0	1	1	1	0	0	1	3206	77
	265	0	1	0	1	0	0	1	2410	71
	266	0	1	1	0	1	0	0	3805	76
	267	0	1	0	0	0	0	0	2693	77
	268	0	1	1	0	0	0	0	2404	58
	269	0	1	1	0	0	0	0	2681	68
	270	0	0	1	1	0	0	0	4910	113
	271	0	0	0	1	1	0	0	5563	121
	272	0	0	0	1	0	0	0	3563	94
	273	0	0	0	0	0	0	0	3005	83
	274	0	0	0	1	0	0	0	2686	77
	275	0	0	1	0	0	0	0	4385	102
	276	0	0	0	1	0	0	0	3687	97
	277	0	0	0	1	0	0	0	3661	96
	278	0	0	0	1	0	0	0	3169	86
	279	0	1	1	0	1	0	0	3392	67
	280	0	1	0	0	0	0	0	2544	74
	281	0	1	1	0	0	0	0	3373	80
	282	0	1	0	0	0	0	0	1969	62
	283	0	1	1	0	0	0	0	2963	72
	284	0	1	0	1	1	0	1	5291	120
	285	0	1	1	0	1	0	0	3515	75
	286	0	0	1	1	1	0	0	6172	123
	287	0	1	1	0	0	0	0	3459	84
	288	0	0	0	1	0	0	0	3274	88
	289	0	1	0	0	0	0	0	2178	67
	290	0	1	0	1	0	0	1	2448	72
	291	0	1	0	1	0	0	1	3770	98
	292	0	0	0	0	0	0	0	3947	102
	293	0	1	1	0	0	0	0	2485	63
	294	0	0	1	0	0	0	0	3234	77
	295	0	0	1	0	0	0	0	3739	87
	296	0	0	1	0	0	0	0	4993	116
	297	0	0	0	1	0	0	0	2771	78
	298	0	0	0	0	0	0	0	2807	79
	299	0	0	0	1	1	0	0	4247	93
	300	0	0	0	0	0	0	0	3362	90
HW3_Data2
	Post ID	Photo	Video	Promotion	Link	Ads	Posting days	Views	Likes	PostingDay			Dummy Variable
	1	1	0	1	0	1	5	7406	170	Friday		Monday	1
	2	1	0	0	0	1	2	6680	156	Tuesday		Tuesday	2
	3	1	0	1	0	1	4	6439	136	Thursday		Wednesday	3
	4	1	0	1	0	0	3	6607	172	Wednesday		Thursday	4
	5	1	0	1	1	0	4	5835	139	Thursday		Friday	5
	6	1	0	1	1	0	5	6159	155	Friday		Saturday	6
	7	1	0	0	0	0	4	5616	142	Thursday		Sunday	7
	8	1	0	0	0	0	5	5630	147	Friday
	9	1	0	0	1	0	4	5589	152	Thursday
	10	1	0	1	0	0	2	6038	147	Tuesday
	11	1	0	0	1	0	4	6073	164	Thursday
	12	1	0	1	0	0	4	5509	130	Thursday
	13	1	0	0	1	0	4	5532	160	Thursday
	14	1	0	1	1	0	5	7028	171	Friday
	15	1	0	0	1	0	6	5678	153	Saturday
	16	1	0	1	0	0	6	6509	157	Saturday
	17	1	0	1	0	0	1	6593	153	Monday
	18	1	0	1	0	0	6	6134	142	Saturday
	19	1	0	0	0	0	1	5452	152	Monday
	20	1	0	0	1	0	5	5462	139	Friday
	21	1	0	0	1	0	6	6562	174	Saturday
	22	1	0	0	1	0	4	5289	153	Thursday
	23	1	0	0	0	1	6	6088	143	Saturday
	24	1	0	0	1	1	4	6451	163	Thursday
	25	1	0	0	0	0	6	5240	135	Saturday
	26	1	0	0	1	0	4	5956	168	Thursday
	27	1	0	1	1	0	2	6705	166	Tuesday
	28	1	0	1	1	0	4	7156	165	Thursday
	29	1	0	1	0	0	5	6177	155	Friday
	30	1	0	0	0	0	1	5551	149	Monday
	31	1	0	0	0	0	5	5513	139	Friday
	32	1	0	1	0	1	1	6541	146	Monday
	33	1	0	0	0	0	7	6830	174	Sunday
	34	1	0	0	1	0	4	6318	168	Thursday
	35	1	0	0	0	0	5	5847	139	Friday
	36	1	0	1	1	0	7	7792	196	Sunday
	37	1	0	0	0	1	5	7020	173	Friday
	38	1	0	1	1	0	4	7403	174	Thursday
	39	1	0	0	0	0	5	5557	146	Friday
	40	1	0	1	1	0	5	7576	188	Friday
	41	1	0	0	1	0	5	6860	170	Friday
	42	1	0	0	0	0	5	6075	164	Friday
	43	1	0	1	0	0	4	4553	107	Thursday
	44	1	0	0	0	0	5	5922	162	Friday
	45	1	0	1	0	0	5	5739	148	Friday
	46	1	0	1	0	0	5	6119	161	Friday
	47	1	0	1	1	1	4	6317	143	Thursday
	48	1	0	0	0	0	2	5540	156	Tuesday
	49	1	0	0	1	0	4	6409	172	Thursday
	50	1	0	0	0	0	4	5917	160	Thursday
	51	1	0	0	0	0	4	4731	118	Thursday
	52	1	0	0	0	0	2	5659	152	Tuesday
	53	1	0	0	0	0	2	5369	151	Tuesday
	54	1	0	0	0	0	4	5565	158	Thursday
	55	1	0	0	1	1	4	7137	176	Thursday
	56	1	0	1	1	0	4	6040	141	Thursday
	57	1	0	1	0	0	4	5312	129	Thursday
	58	1	0	1	0	0	4	6059	158	Thursday
	59	1	0	0	1	0	4	5443	150	Thursday
	60	0	1	0	0	1	2	2987	64	Tuesday
	61	1	0	0	1	1	4	7428	177	Thursday
	62	1	0	0	0	1	4	5850	133	Thursday
	63	0	1	1	1	1	3	5062	105	Wednesday
	64	1	0	0	1	0	4	6555	170	Thursday
	65	1	0	0	1	0	4	4875	136	Thursday
	66	1	0	0	0	0	5	5939	155	Friday
	67	1	0	1	0	0	7	7799	191	Sunday
	68	0	1	0	0	0	5	2033	64	Friday
	69	1	0	1	0	0	5	6623	176	Friday
	70	1	0	0	1	0	7	6204	162	Sunday
	71	1	0	1	1	0	5	6928	175	Friday
	72	1	0	0	1	0	5	5528	145	Friday
	73	0	1	1	0	0	6	3254	78	Saturday
	74	1	0	1	1	0	5	7468	171	Friday
	75	1	0	1	0	0	6	6357	159	Saturday
	76	1	0	0	1	0	5	6721	176	Friday
	77	1	0	0	1	0	5	5064	137	Friday
	78	1	0	0	1	0	5	7286	184	Friday
	79	0	1	0	0	0	5	2104	65	Friday
	80	1	0	0	0	0	5	5563	150	Friday
	81	1	0	0	0	0	6	5920	162	Saturday
	82	1	0	0	0	0	7	6873	180	Sunday
	83	1	0	0	0	1	5	6329	157	Friday
	84	1	0	1	1	1	7	8915	185	Sunday
	85	1	0	1	0	0	3	6605	166	Wednesday
	86	1	0	1	1	0	4	6733	165	Thursday
	87	1	0	0	0	0	4	5629	157	Tuesday
	88	1	0	0	1	0	4	5406	144	Thursday
	89	1	0	1	0	0	4	5886	136	Thursday
	90	1	0	0	1	0	4	6046	144	Tuesday
	91	1	0	0	1	0	4	4704	124	Thursday
	92	1	0	0	0	1	4	6362	162	Thursday
	93	1	0	1	0	0	4	5562	145	Thursday
	94	1	0	0	0	0	2	5639	151	Tuesday
	95	1	0	1	0	0	4	5355	131	Thursday
	96	0	1	0	0	0	2	2604	75	Tuesday
	97	1	0	1	1	1	4	7196	163	Thursday
	98	1	0	0	0	0	4	5146	140	Thursday
	99	1	0	0	1	0	4	6338	161	Thursday
	100	1	0	1	0	0	3	5905	143	Wednesday
	101	1	0	0	0	0	4	5172	147	Thursday
	102	1	0	1	0	0	5	6312	157	Friday
	103	1	0	0	0	0	4	4549	124	Thursday
	104	0	1	1	0	0	4	3166	77	Thursday
	105	1	0	1	1	0	4	6520	160	Thursday
	106	1	0	1	1	0	5	7339	171	Friday
	107	0	1	1	0	1	5	4834	98	Friday
	108	1	0	0	0	0	4	5243	140	Thursday
	109	1	0	0	1	0	6	7129	181	Saturday
	110	0	1	0	0	0	6	2620	75	Saturday
	111	1	0	1	1	0	5	6766	152	Friday
	112	1	0	0	0	0	6	5795	155	Saturday
	113	0	1	1	1	0	6	3934	91	Saturday
	114	1	0	0	1	0	6	5058	138	Saturday
	115	1	0	1	1	1	6	7947	172	Saturday
	116	0	1	0	0	0	5	2364	70	Friday
	117	1	0	1	0	0	5	6236	156	Friday
	118	1	0	1	0	0	5	6336	157	Friday
	119	1	0	1	0	0	3	6399	149	Wednesday
	120	1	0	0	1	1	4	6742	162	Thursday
	121	0	1	0	1	1	2	4538	98	Tuesday
	122	0	1	0	1	1	4	4035	91	Thursday
	123	0	1	0	0	1	4	3122	73	Thursday
	124	0	1	0	1	0	4	2336	70	Thursday
	125	0	1	0	0	0	5	2515	73	Friday
	126	0	1	0	1	0	5	3021	83	Friday
	127	0	1	0	1	0	6	3305	89	Saturday
	128	0	1	1	1	0	5	3262	78	Friday
	129	0	1	1	0	0	6	3132	76	Saturday
	130	0	1	1	0	0	6	3354	82	Saturday
	131	0	1	0	0	0	6	3143	86	Saturday
	132	0	1	0	0	0	4	2890	81	Thursday
	133	0	1	1	0	0	4	2791	69	Thursday
	134	0	1	0	1	0	3	2487	73	Wednesday
	135	0	1	0	0	0	4	2492	73	Thursday
	136	0	1	0	1	0	4	3800	99	Thursday
	137	1	0	1	0	0	4	5520	142	Thursday
	138	1	0	0	1	0	4	6388	172	Thursday
	139	1	0	1	0	0	4	6840	172	Thursday
	140	1	0	0	1	0	5	6425	170	Friday
	141	1	0	1	1	0	6	6426	155	Saturday
	142	1	0	0	0	0	5	6542	184	Friday
	143	1	0	0	0	1	6	6297	153	Saturday
	144	1	0	1	0	1	3	7610	179	Wednesday
	145	1	0	0	0	0	4	4693	133	Thursday
	146	1	0	1	0	0	2	6382	158	Tuesday
	147	1	0	1	1	0	4	5711	148	Thursday
	148	1	0	1	0	0	4	5081	122	Thursday
	149	1	0	0	1	0	5	5339	146	Friday
	150	1	0	0	0	0	6	5325	146	Saturday
	151	1	0	0	0	0	5	5752	153	Friday
	152	1	0	0	0	1	6	6471	157	Saturday
	153	1	0	0	0	0	6	5482	157	Saturday
	154	1	0	0	0	0	6	5128	137	Saturday
	155	1	0	0	1	0	4	6308	170	Thursday
	156	1	0	0	1	0	2	5941	163	Tuesday
	157	1	0	1	0	1	4	6637	141	Thursday
	158	1	0	1	0	0	4	5312	134	Thursday
	159	1	0	1	1	0	4	6014	144	Thursday
	160	1	0	0	0	0	5	5990	158	Friday
	161	1	0	0	1	0	5	4984	130	Friday
	162	1	0	0	0	0	5	5617	155	Friday
	163	1	0	0	1	0	4	6118	163	Thursday
	164	0	1	1	1	0	5	3132	75	Friday
	165	0	0	0	1	0	1	3335	90	Monday
	166	0	1	0	0	0	7	3951	102	Sunday
	167	0	1	0	0	1	7	5149	117	Sunday
	168	0	0	1	0	0	1	3980	94	Monday
	169	0	1	0	0	0	7	3566	94	Sunday
	170	0	1	1	1	0	1	2956	72	Monday
	171	0	1	0	1	0	5	2498	73	Friday
	172	0	1	1	1	0	5	4356	100	Friday
	173	0	1	0	0	0	4	2374	70	Thursday
	174	0	1	1	1	0	4	2204	56	Thursday
	175	0	0	1	0	1	2	4815	104	Tuesday
	176	0	1	1	1	0	3	3384	79	Wednesday
	177	0	1	0	1	0	2	2234	68	Tuesday
	178	0	1	0	1	0	3	3892	101	Wednesday
	179	0	1	0	0	0	3	1794	59	Wednesday
	180	0	1	0	0	1	5	3162	74	Friday
	181	0	0	1	0	0	6	3722	88	Saturday
	182	0	1	0	0	0	6	2176	67	Saturday
	183	0	1	0	0	0	6	2608	75	Saturday
	184	0	0	0	1	0	6	2802	79	Saturday
	185	0	1	1	0	0	5	3394	82	Friday
	186	0	1	0	1	0	3	2074	64	Wednesday
	187	0	1	1	0	0	3	3190	77	Wednesday
	188	0	1	0	1	1	3	4249	98	Wednesday
	189	0	1	1	0	0	3	3401	82	Wednesday
	190	0	1	0	1	0	3	3614	95	Wednesday
	191	0	1	1	1	0	5	3064	73	Friday
	192	0	1	1	0	0	5	3700	87	Friday
	193	0	1	1	0	1	2	4228	83	Tuesday
	194	0	0	0	0	1	5	4581	104	Friday
	195	0	1	0	0	1	2	4018	90	Tuesday
	196	0	1	1	0	0	5	3284	74	Friday
	197	0	1	0	1	0	2	3578	95	Tuesday
	198	0	1	1	0	0	5	3323	80	Friday
	199	0	1	1	1	0	7	5128	116	Sunday
	200	0	1	1	0	0	5	2926	72	Friday
	201	0	1	1	0	0	5	3369	80	Friday
	202	0	1	0	0	0	7	3228	88	Sunday
	203	0	0	0	0	0	5	3522	93	Friday
	204	0	0	0	0	0	7	4462	112	Sunday
	205	0	0	1	1	0	5	4918	114	Friday
	206	0	1	0	1	0	7	4145	106	Sunday
	207	0	1	1	0	0	7	4467	105	Sunday
	208	0	1	0	0	1	2	4077	88	Tuesday
	209	0	0	1	1	0	5	4833	109	Friday
	210	0	0	0	0	0	5	3445	92	Friday
	211	0	1	1	1	0	3	3572	84	Wednesday
	212	0	1	1	0	1	5	3935	75	Friday
	213	0	1	1	1	1	5	5269	108	Friday
	214	0	1	0	1	1	2	5321	121	Tuesday
	215	0	0	0	1	0	3	4162	106	Wednesday
	216	0	1	0	0	0	5	3067	84	Friday
	217	0	1	0	0	0	2	2825	79	Tuesday
	218	0	1	0	0	0	5	2601	75	Friday
	219	0	1	0	0	0	7	3926	102	Sunday
	220	0	1	0	1	0	3	2925	82	Wednesday
	221	0	0	0	1	0	3	3428	92	Wednesday
	222	0	1	1	1	0	3	3275	76	Wednesday
	223	0	1	1	0	0	3	3363	81	Wednesday
	224	0	1	1	1	0	3	3609	84	Wednesday
	225	0	1	0	0	0	3	1833	60	Wednesday
	226	0	1	0	1	0	2	2546	74	Tuesday
	227	0	1	1	1	0	3	1865	46	Wednesday
	228	0	1	0	1	0	3	3254	88	Wednesday
	229	0	0	0	0	0	3	3319	89	Wednesday
	230	0	0	0	0	0	2	3160	86	Tuesday
	231	0	0	1	0	0	3	3866	89	Wednesday
	232	0	0	0	0	0	3	3750	98	Wednesday
	233	0	0	1	0	0	3	3943	92	Wednesday
	234	0	0	0	1	1	3	4281	101	Wednesday
	235	0	0	1	0	1	2	5145	104	Tuesday
	236	0	1	0	1	0	2	3320	89	Tuesday
	237	0	1	0	0	0	3	2583	75	Wednesday
	238	0	1	1	1	0	3	3727	89	Wednesday
	239	0	1	0	0	0	3	1567	54	Wednesday
	240	0	1	1	1	0	3	3482	85	Wednesday
	241	0	1	1	1	0	5	4068	93	Friday
	242	0	0	1	0	0	5	3274	78	Friday
	243	0	0	0	0	1	7	5101	113	Sunday
	244	0	0	0	0	0	5	3408	91	Friday
	245	0	0	0	0	0	1	3469	92	Monday
	246	0	1	0	0	0	5	2705	77	Friday
	247	0	1	0	1	0	1	2335	70	Monday
	248	0	1	0	0	1	4	2756	62	Thursday
	249	0	1	0	1	0	2	3149	86	Tuesday
	250	0	1	0	0	0	4	2593	75	Thursday
	251	0	1	1	0	0	2	2930	72	Tuesday
	252	0	0	1	0	0	2	3701	87	Tuesday
	253	0	0	1	0	0	4	3708	87	Thursday
	254	0	0	0	0	0	5	2736	78	Friday
	255	0	0	0	1	0	1	3823	99	Monday
	256	0	0	0	1	0	5	3022	83	Friday
	257	0	0	0	0	0	7	4850	120	Sunday
	258	0	0	1	0	1	5	5070	107	Friday
	259	0	0	0	1	0	7	5012	123	Sunday
	260	0	0	0	0	0	5	3866	100	Friday
	261	0	0	0	1	0	4	3617	95	Thursday
	262	0	0	1	0	0	4	4204	101	Thursday
	263	0	0	0	1	0	4	3270	88	Thursday
	264	0	1	1	1	0	4	3206	77	Thursday
	265	0	1	0	1	0	2	2410	71	Tuesday
	266	0	1	1	0	1	4	3805	76	Thursday
	267	0	1	0	0	0	4	2693	77	Thursday
	268	0	1	1	0	0	4	2404	58	Thursday
	269	0	1	1	0	0	4	2681	68	Thursday
	270	0	0	1	1	0	1	4910	113	Monday
	271	0	0	0	1	1	1	5563	121	Monday
	272	0	0	0	1	0	1	3563	94	Monday
	273	0	0	0	0	0	1	3005	83	Monday
	274	0	0	0	1	0	1	2686	77	Monday
	275	0	0	1	0	0	1	4385	102	Monday
	276	0	0	0	1	0	2	3687	97	Tuesday
	277	0	0	0	1	0	1	3661	96	Monday
	278	0	0	0	1	0	1	3169	86	Monday
	279	0	1	1	0	1	1	3392	67	Monday
	280	0	1	0	0	0	1	2544	74	Monday
	281	0	1	1	0	0	5	3373	80	Friday
	282	0	1	0	0	0	1	1969	62	Monday
	283	0	1	1	0	0	5	2963	72	Friday
	284	0	1	0	1	1	1	5291	120	Monday
	285	0	1	1	0	1	1	3515	75	Monday
	286	0	0	1	1	1	5	6172	123	Friday
	287	0	1	1	0	0	1	3459	84	Monday
	288	0	0	0	1	0	1	3274	88	Monday
	289	0	1	0	0	0	1	2178	67	Monday
	290	0	1	0	1	0	1	2448	72	Monday
	291	0	1	0	1	0	2	3770	98	Tuesday
	292	0	0	0	0	0	2	3947	102	Tuesday
	293	0	1	1	0	0	1	2485	63	Monday
	294	0	0	1	0	0	1	3234	77	Monday
	295	0	0	1	0	0	2	3739	87	Tuesday
	296	0	0	1	0	0	3	4993	116	Wednesday
	297	0	0	0	1	0	1	2771	78	Monday
	298	0	0	0	0	0	1	2807	79	Monday
	299	0	0	0	1	1	1	4247	93	Monday
	300	0	0	0	0	0	2	3362	90	Tuesday
Q1
	Please run a regression analysis to estimate the effects of content features on the number of views a post receives using the data in worksheet HW3_Data1
	Fill in the blank in the following tables
	Regression Statistics
	Multiple R	0.9245882419
	R Square	0.8548634171
	Observations	300
		Coefficients	Standard Error	t Stat	P-value
	Intercept	3356.0756127979	92.2050752911	36.3979488353	6.39484251672409E-111
	Photo	2187.4721778729	96.6070437224	22.6429884777	2.11338508901414E-66
	Video	-761.6137040765	100.0666250637	-7.6110661631	0
	Promotion	577.0856491625	71.3678745664	8.0860702756	0
	Link	421.4119681716	70.9399816884	5.940401423	0.000000008
	Ads	1058.9335066365	93.6598488113	11.306162887	7.50398538292878E-25
	You wonder whether there will be interaction effects between content features, especially between content format (whether it is a photo, video, or text) and link inclusion of the post (whether a link is included in the post).  
	You decide to create two additional variables, plink (photo*link) and vlink (photo*link), and include them in the regression model.  Please fill in the blank in the follow tables based on your new regression results.   
	Regression Statistics
	Multiple R	0.9252977728
	R Square	0.8561759683
	Observations	300
		Coefficients	Standard Error	t Stat	P-value
	Intercept	3461.4473037578	112.6850249835	30.7178997765	1.81649859635263E-93
	Photo	2058.4165944774	126.6356852767	16.2546330442	9.32357250104771E-43
	Video	-879.0534476045	130.6699428918	-6.72728118	0.0000000001
	Promotion	565.6096517612	71.6631450314	7.892615535	0
	Ads	177.257016434	166.2268048731	1.0663563952	0.2871434505
	Link	1063.174044169	93.5997393412	11.3587286851	5.24816318503554E-25
	plink	309.2345023845	196.0307508386	1.577479559	0.1157679254
	vlink	283.4878152295	203.4434322845	1.3934478594	0.164544119
	Is there any statistically significant interaction effect between content format and link inclusion?
	Since, the p value of plink and vlink is more than 0.05, it is concluded that there is no significant interaction effect between content format and link inclusion fo rthe no of views
Q2
	Now we also obtain information on posting day for each of the posts in our dataset.  See workseet HW3_Data2 for the information on posting day
	Please run a regression analysis to estimate the effects of content features and posting day on the number of views a post receives using the data in worksheet HW3_Data2
	Hint: use Monday as the baseline, create dummy variables for Tuesday, Wednesday, Thursday, Friday, Saturday and Sunday
	Fill in the blank in the following tables
	SUMMARY OUTPUT
	Regression Statistics
	Multiple R	0.9335058432
	R Square	0.8714331592
	Observations	300
		Coefficients	Standard Error	t Stat	P-value
	Intercept	2929.2970840529	111.266494444	26.3268569635	3.39269220220197E-79
	Photo	2023.0090783723	94.931077806	21.3102929528	1.65571791294063E-61
	Video	-849.9232074803	95.4302623827	-8.9062231022	5.69301710659987E-17
	Promotion	576.3814270441	67.28515965	8.5662489328	6.18891332248455E-16
	Link	457.3135729371	67.136337101	6.8117146792	0.0000000001
	Ads	1093.6289268699	88.4820787425	12.3598918833	1.58380883343514E-28
	Posting days	129.1803676851	21.0217718015	6.1450751585	0.0000000026
	Based on your analysis, what is your conclusion?
	Since, p value of Intercept and all the dependent variables are less than 0.05, it is concluded that there is significant effect of content features and posting date on the number of views.
Q3
	Repeat the analysis you perform in Q1 and Q2 for the number of likes a post receives.
	Repeatation of Q1 for Number of likes a post receives								Repeatation of Q2 for Number of likes a post receives
	Regression Statistics								SUMMARY OUTPUT
	Multiple R	0.932291945
	R Square	0.8691682706							Regression Statistics
	Observations	300							Multiple R	0.9335058432
									R Square	0.8714331592
		Coefficients	Standard Error	t Stat	P-value				Observations	300
	Intercept	90.5736891141	2.1176145667	42.7715650138	2.96961728003451E-128
	Photo	58.9846411957	2.21871174	26.5850854499	3.47090004422373E-80					Coefficients	Standard Error	t Stat	P-value
	Video	-15.8377134566	2.298165716	-6.8914584124	0				Intercept	81.9345435253	2.5918670517	31.6121706442	2.01126686784879E-96
	Promotion	1.4046632449	1.6390600008	0.8569931816	0.3921466581				Photo	55.6554656049	2.2113461377	25.168138382	3.21896591613011E-75
	Link	8.4462870028	1.6292328607	5.1842110521	0.0000004042				Video	-17.6253353855	2.2229742569	-7.9287177217	0
	Ads	9.1885362985	2.151025413	4.2717004844	0.0000262239				Promotion	1.3904078946	1.5673558265	0.8871041732	0.3757503898
									Link	9.1730320697	1.5638891202	5.8655258555	0.0000000121
	Since, the p value of plink and vlink is less than 0.05 for all the dependent variables,								Ads	9.8908649455	2.0611216854	4.7987777799	0.0000025472
	 it is concluded that there is significant effect of content format on number of likes								Posting days	2.6149581773	0.489685938	5.3400720224	0.0000001867
	Regression Statistics								Since, p value of Intercept and all the dependent variables are less than 0.05, it is concluded that 
	Multiple R	0.932884511							there is significant effect of content features and posting date on the number of views.
	R Square	0.8702735108
	Observations	300
		Coefficients	Standard Error	t Stat	P-value
	Intercept	92.9179839376	2.5887421989	35.8931005096	4.38771619485951E-109
	Photo	56.1396032339	2.9092343229	19.2970372967	4.64448448300134E-54
	Video	-18.4814720561	3.0019143656	-6.1565620484	0.0000000025
	Promotion	1.1482130876	1.6463359499	0.6974354703	0.4860852373
	Ads	3.0149414217	3.8187713445	0.7895056157	0.4304571596
	Link	9.2837903051	2.1502909998	4.3174576399	0.000021644
	plink	6.818620434	4.503465097	1.5140831087	0.1310863996
	vlink	6.382226222	4.6737585435	1.365544703	0.173132892
	Since, the p value of plink and vlink is more than 0.05, it is concluded that 
	there is no significant interaction effect between content format and link inclusion fo rnumber of likes

Uploaded The Assignment

Answer To: Uploaded The Assignment

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment