annotated-Hw7assignment.docx
pdf
keyboard_arrow_up
School
University of Arkansas *
*We aren’t endorsed by this school
Course
MISC
Subject
Information Systems
Date
Feb 20, 2024
Type
Pages
3
Uploaded by ProfessorAardvark3958
Name: Saikiran Miriyala
UID: U00912779
MIS 7710 – Web Analytics
Fall 2023
Email Marketing Campaign Analytics (HW Assignment:7)
Part A (25 points)
1
Run a regression model in Excel.
2
Look at your statistical output and answer the following questions:
1
What is your regression equation? (10 points)
A . Regression equation is Y=a+bX
X=independent variable
Y= dependent variable
a= intercept
b=coefficient
Y=0.0412081148020742+0.0119888056354352X
a=0.0412081148020742
b=0.0119888056354352
2.
How does your dependent variable change when your independent variable increases by 1 unit? (5 points)
A . By analysis we got coefficient positive value b is positive it means in increase of every 1unit in
is_personalised click_rate is expected to increase by 0.0119 units 3.
Are the p-values for your intercept and variable coefficient statistically significant? (5 point)
A . p-value for the intercept is 1.32090804889541E-85 is less than 0.05 so it is statistically significant.
p-value for the coefficient is 0.152737591140898 is greater than 0.05 so it is not statistically significant.
4
What is the R-squared for this model? (5 point)
A . The R-squared for this model is : 0.00108384334798136
IF R-squared value is high means that indicates that it have good click rate and r-squared value tells us that variance in the dependent variable which can be explained by independent variable.By this analysis and result we got to know that there is small correlation between dependent and independent variables.
Part B (30 points)
4.
Select one more additional independent variable of your choice and run a multiple regression model in Excel. 1
What is your regression equation?
(10 points)
A . Regression equation Y= Regression equation is Y= 0.0230945395297114+ 0.00149366858197818X1+ 0.00149366858197818x2
X1=independent variable=is_personalised
X2=independent variable=mean_paragraph_len
Y= dependent variable
a= intercept
b=coefficient 2
How does your dependent variable change when each of your independent variables increase by 1 unit? (5 points)
A.
By increase of independent variable is personalized by 1unit leads increase in the click rate by 0.00149366858197818.By increase of independent variable mean_paragraph_len by 1unit leads increase in the click rate by 0.000530893551658462
3
Are p-values for your intercept and variables’ coefficients statistically significant? (5 points)
A . p-values of intercept is 6.86264593898819E-14 is less than 0.05 so it is statistically significant
p-values of 1
st
independent variable 0.858295331072208 it is not statistically significant because it is greater than 0.05
p-values of 2nd independent variable 1.84351187769127E-14 is less than 0.05 so it is statistically significant
4
What is the R-squared? (5 points)
A . The R-squared for this model is : 0.0317154007507508 IF R-squared value is high means that indicates that it have good click rate and r-squared value tells us that variance in the dependent variable which can be explained by independent variable
5
Is your overall model statistically significant? (5 points)
In this model of analysis if we want to tell whether it is significant or not we should check whether the value of significance is less than 0.05 in this model or the data set the of value of significance f is 6.42819131257966E-14 which is less than 0.05 so it is statistically significant.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help