2.9 A study of Kickstarter projects showed that 54.2% were successful, that is,
ID: 3371606 • Letter: 2
Question
2.9 A study of Kickstarter projects showed that 54.2% were successful, that is, achieved its goal and raised at least the targeted goal amount. In an effort to identify network dynamics that influences success, projects were subdivided into projects of owners who had backed other projects before, during or after creating their project (owners with backing history) and projects of owners without backing history. The results are as follows:
Project Outcome
Backing
History
No Backing
History Total
Successful 17,667 19,202 36,869
Not successful 10,921 20,267 31,188
Total 28,588 39,469 68,057
a. Construct contingency tables based on total
b. Which type of percentage—row, column, or total—do you
think is most informative for these data? Explain.
c. What conclusions concerning the pattern
***CAN YOU PLEASE NOT ONLY EXPLAIN AND SHOW ANSWERS, BUT HOW TO CREATE THESE TABLES IN EXCEL. THANK YOU!!!***
Explanation / Answer
The Observed value:
Project outcome
Backing hist
No Backing hist
total
successful
17667
19202
36869
not successful
10921
20267
31188
total
28588
39469
68057
To obtain expected value: we have formula = ((Row total)(Column Total))/grand total
Project Outcome
Backing hist
No Backing hist
Total
successful
15487.17945
21381.82055
36869
not successful
13100.82055
18087.17945
31188
total
68057
we arranged table to calculate Chi-Sq:
successful
not Successful
total
Y=(Obsved-Exptd)^2
Z=Y/Exptd
Obsv. Back hist
17667
10921
28588
4751617.619
306.8097476
Obsv. No Back hist
19202
20267
39469
4751617.619
362.696184
Total
36869
31188
68057
Expted. Back hist
15487.17945
13100.82055
4751617.619
222.2269899
Expted. No Back hist
21381.82055
18087.17945
4751617.619
262.70639
Chi-square =sum(z)=1154.44
Step:
1. we create observed value table
2. using the formula of expected value we can create expected value table in excel
3. compute formula (obsrved-expected)^2/expected
4.take sum of all in step 3 values which is nothing but Chi Sq statistics.
p<0.05 the result is significant at 5% level of significance
we conclude that In an effort to identify network dynamices that does not influences success
The Observed value:
Project outcome
Backing hist
No Backing hist
total
successful
17667
19202
36869
not successful
10921
20267
31188
total
28588
39469
68057
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.