Alice, a micro$-$entrepreneur, is planning to develop a fashion product. She is considering launching a

campaign on a crowdfunding platform. However, Alice is not familiar with the crowdfunding

campaign and would like to seek some insights about predicting the success of her campaign.

You, a student has taken class $1$ to $13$ of MKTG$/$BADM $3661,$ are asked to help Alice understand

these issues. You collect the data $$Crowdfunding$.$xlsx$$ from the crowdlending platform.

A$)$ Multiple$-$choice questions $($you only need to answer the correct choice for each of the

following questions, no explanations are required$).$

$9.$ Among all crowdfunding campaigns in this data, what is the funding probability? $(3$ points$)$

A$.47\mathrm{.}11\%.$

B$.57\mathrm{.}59\%.$

C$.48\mathrm{.}48\%.$

D$.$ None of above.

$10.$ Alice conducts a regression analysis in which the DV is $$success$$ and IVs are $$novel$$ and

$$useful$.$ Then, Alice says $$Since the $$useful$$ variable has an insignificant effect on $$success$,$ it

should be excluded from the prediction model.$$ What is your feedback on Alice$$s underlined

statement? $(3$ points$)$

A$.$ Alice$$s underlined statement is true.

B$.$ Alice$$s underlined statement is false.

C$.$ There is not enough information to determine whether Alice$$s underlined statement is true

or false.

B$)$ Short answer questions $($you need to show your work to get full credits, please include your

Excel worksheets in your submission$)$

$11.$ After reading Alice$$s project description of her campaign, you find that the project has a novelty

index $12\mathrm{.}18$ and a usefulness index $17\mathrm{.}25.$ Alice would like to know your prediction of the funding

probability of her campaign. What is your answer? Explain.

Note: If you can use the available information to predict the funding probability for Alice$$s

campaign, then your answer needs to include your regression model, your regression results, and

your predictions. If you cannot use the available information to make the prediction, then your

answer needs to explain why. $(10$ points$)$

$7$

$12.$ Alice thinks that in order to increase the funding probability, she should revise her project

description to make it more novel. The revised project description maintains the same usefulness

index but increases its novelty index to $32\mathrm{.}18.$

Alice wants to know how this revision $($i$.$e$.,$ increasing the novelty index to $32\mathrm{.}18)$ would affect the

predicted funding probability for her campaign. What is your answer? Explain.

Note: If you can use the available information to show the change in the predicted funding

probability, then your answer needs to include your regression model, your regression results, and

your conclusions. If you cannot use the available information to show the change, then your

answer needs to explain why. $(10$ points$)$