Answered step by step
Verified Expert Solution
Link Copied!
Question
1 Approved Answer

Among the factors believed to drive success are budget (expressing both the cost of the novel and the writer's fee), genre (romantic vs. non-romantic), bookstore

Among the factors believed to drive success are budget (expressing both the cost of the novel and the writer's fee), genre (romantic vs. non-romantic), bookstore classification ratings (general (G) vs. other grades) The familiarity of the story (whether the novel is a sequel or adapted from a known story).


Opening book.com salesTotal book.com salesBudgetKnown StorySequelGenreClassification ratings Critics´ Opinion
13,337,16841,507,034 50,625,00000Action PG-1363
11,276,81440,863,943 25,875,00000RomanticPG-1347
16,881,30557,224,964 45,000,00000AdventureGeneral68
4,831,80317,024,358 96,750,00000Kids & FamilyMature Accompanied 39
12,998,70523,816,883 22,500,00000DramaPG-1363
6,252,85738,590,692 22,500,00000DramaGeneral69
17,798,47281,717,528 57,375,00000Kids & FamilyMature Accompanied 42
31,203,06378,936,719 45,000,00001RomanticPG-1334
9,729,36564,550,156 112,500,00000DramaGeneral63
12,889,52292,924,739 95,625,00010RomanticMature68
11,472,49739,743,739 85,500,00010Military & WarGeneral84
45,012,786154,525,087 92,812,50000RomanticPG-1345
16,541,33165,655,855 56,250,00010Kids & FamilyMature62
21,460,79454,616,979 22,500,00000RomanticPG-1311
23,146,65272,043,443 84,375,00000Military & WarPG-1359
10,072,951116,286,701 84,375,00000DramaPG-1376
22,711,69891,814,136 45,000,00010DramaMature Accompanied 64
26,144,89584,408,933 112,500,00010ActionMature Accompanied 38
27,462,73799,804,591 56,250,00000RomanticPG-1347
21,569,73160,860,307 28,125,00001HorrorGeneral41
11,525,83937,802,673 101,250,00010ActionGeneral79
6,754,74614,726,959 67,500,00000ActionPG-1347
16,216,45943,236,926 33,750,00000DramaPG-1352
46,725,111222,750,357 112,500,00000Kids & FamilyMature Accompanied 77
76,537,737219,746,949 90,000,00001Kids & FamilyMature Accompanied 58
32,574,31399,577,682 50,625,00000Military & WarGeneral76
6,403,82119,492,481 31,500,00000RomanticPG-1329
20,299,94647,570,815 78,750,00000DramaPG-1336
14,406,96243,199,956 50,625,00010DramaPG-1352
24,314,82365,975,684 72,000,00000RomanticPG-1326


Questions:


A. Based on the beliefs described, determine a reliable regression model in EXCEL that predicts total novel sales for book.com prior to production.

 (hint: use the logarithm of the total book.com as dependent variable, see function LN in EXCEL.)

 

B. Remove all variables that are not significant at the 10% significance level from the regression in EXCEL. The report finally came back.

 

C. Holding all other explanatory variables in the regression constant, which novels have higher total book.com sales, which are sequels, and which are not?


Step by Step Solution

3.40 Rating (166 Votes )

There are 3 Steps involved in it

Step: 1

To determine a reliable regression model in Excel that predicts total novel sales for bookcom prior to production you can follow these steps Step 1 Or... blur-text-image
Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Business Statistics

Authors: Norean Sharpe, Richard Veaux, Paul Velleman

3rd Edition

978-0321944726, 321925831, 9780321944696, 321944720, 321944690, 978-0321925831

More Books

Students also viewed these Accounting questions