Question

In: Statistics and Probability

Data from 2010 & 2011, in millions (source: Billboard Magazine): Company            Annual Revenue Market Valuation Spotify           &nbsp

Data from 2010 & 2011, in millions (source: Billboard Magazine):

Company            Annual Revenue Market Valuation

Spotify                145 3,000

Warner Music     2,888                   3,300

Live Nation         5,600                   1,700

Pandora 241 1,300

EMI                    1,800                   1,900

3a) Find the correlation between annual revenue and market valuation. Is it statistically significant?

3b) Why is the correlation between revenue and market valuation so low?.

Solutions

Expert Solution

Answers:

*******************************************************************************************************************************

Given data:

Annual Revenue Market Validation
1450 3000
2888 3300
5600 1700
2410 1300
1800 1900

*********************************************************************************************************************************

Ans 3a)

The correlation between annual revenue and market valuation is,

Annual Revenue Market Validation
Annual Revenue 1 -0.088819234
Market Validation -0.088819234 1
Coefficients Standard Error t Stat P-value Lower 95% Upper 95%
Intercept 4130.86631 2477.238932 1.667528 0.194001 -3752.813576 12014.5462
Market Validation -0.58092246 1.045332245 -0.55573 0.617151 -3.907636201 2.745791281

Here is the p-value is 0.617 which is greater than 0.05 level of significance which means our null hypothesis is accepted and they are statistically insignificant.

**********************************************************************************************************************************

Ans 3b)

The correlation between revenue and market valuation so low because  Annual Revenue is very low in the case of company Spotify and company Pandora. If the Annual Revenue is high then our correlation value will be high.

**********************************************************************************************************************************

orchestra answered 1 year ago
Next > < Previous

Related Solutions

Exxon Mobil Chevron ($millions) 2011 2010 2009 2011 2010 2009 Revenue... $486,429 $383,221 $310,586 $253,706 $204,958...
Exxon Mobil Chevron ($millions) 2011 2010 2009 2011 2010 2009 Revenue... $486,429 $383,221 $310,586 $253,706 $204,958 $171,636 Cost of revenue... 306,802 233,751 185,833 171,572 135,655 117,510 Selling, general, & administrative expenses... 88,459 79,348 75,490 20,373 22,958 22,118 Net income... 41,060 30,460 19,280 26,895 19,024 10,483 Accounts receivable... 38,642 32,284 27,645 21,793 20,759 17,703 Dividends paid... 6326 8,779 8,303 6,210 5,746 5,373 Use the information above to forecast the next two year revenue for Exxon Mobil. Based your forecasts on the...
The following data show the annual revenue ($ millions) and the estimated team value ($ millions)...
The following data show the annual revenue ($ millions) and the estimated team value ($ millions) for the 30 Major League Baseball teams (Forbes website, January 16, 2014). Team Revenue ($ millions) Value ($ millions) Arizona Diamondbacks 195 584 Atlanta Braves 225 629 Baltimore Orioles 206 618 Boston Red Sox 336 1312 Chicago Cubs 274 1000 Chicago White Sox 216 692 Cincinnati Reds 202 546 Cleveland Indians 186 559 Colorado Rockies 199 537 Detroit Tigers 238 643 Houston Astros 196...
The following data show the annual revenue ($ millions) and the estimated team value ($ millions)...
The following data show the annual revenue ($ millions) and the estimated team value ($ millions) for the 30 Major League Baseball teams (Forbes website, January 16, 2014). Team Revenue ($ millions) Value ($ millions) Arizona Diamondbacks 195 584 Atlanta Braves 225 629 Baltimore Orioles 206 618 Boston Red Sox 336 1312 Chicago Cubs 274 1000 Chicago White Sox 216 692 Cincinnati Reds 202 546 Cleveland Indians 186 559 Colorado Rockies 199 537 Detroit Tigers 238 643 Houston Astros 196...
The following data show the annual revenue ($ millions) and the estimated team value ($ millions)...
The following data show the annual revenue ($ millions) and the estimated team value ($ millions) for the 30 Major League Baseball teams (Forbes website, January 16, 2014). Team Revenue ($ millions) Value ($ millions) Arizona Diamondbacks 195 584 Atlanta Braves 225 629 Baltimore Orioles 206 618 Boston Red Sox 336 1312 Chicago Cubs 274 1000 Chicago White Sox 216 692 Cincinnati Reds 202 546 Cleveland Indians 186 559 Colorado Rockies 199 537 Detroit Tigers 238 643 Houston Astros 196...
What data source would you use for a market-based valuation of a public company? A private...
What data source would you use for a market-based valuation of a public company? A private company? What do you need to know about the data and your subject company to provide reasonable assurance of comparability? Are there circumstances when a market-based method would be more or less appropriate than a DCF or operating income based method? What are the limitations of a market-based method?
6. The following data represents a company’s revenue in millions of dollars. Year: 2010 2012 2014...
6. The following data represents a company’s revenue in millions of dollars. Year: 2010 2012 2014 2015 2016 2018 2019 Revenue: 30 32 34 35 39 39 45 Let the year 2010 be the base year with x=0. a) Model the data with a linear function using the points in years 2010 and 2019. Round computed values to 2 decimal places. Also, using your model predict the revenue in the year 2021 accurate to 3 decimal places. b) Set up...
Consider additional data for Archer-Daniels-Midland for fiscal years ending June 30, 2010 and 2011, in millions:...
Consider additional data for Archer-Daniels-Midland for fiscal years ending June 30, 2010 and 2011, in millions: Fiscal Year End (in millions)                June 30, 2011             June 30, 2010 Sales                          $80,676                       $61,682 Cost of goods sold      $76,376                      $57,839 Fiscal Year End (in millions)                June 30, 2011             June 30, 2010 Accounts receivable   $9,816                        $6,122 Inventories                 $12,055                       $7,871 Accounts payable      $11,165                      $8,115 Calculate the DSO, DIO, and DPO for fiscal years ending June...
Year 2012 RM 'millions 2011 RM'millions 2010 RM'millions Annual Amounts: Net Income 90 60 25 Gross...
Year 2012 RM 'millions 2011 RM'millions 2010 RM'millions Annual Amounts: Net Income 90 60 25 Gross margin on sales 520 380 200 Cost of goods sold 980 620 300 Operating expenses 380 295 165 Income tax expense 50 25 10 Dividends declared and paid 35 15 5 End-of-Year Amounts: Long-term assets 240 220 180 Long-term debt 85 65 40 Current liabilities 65 55 35 Cash 20 5 10 Accounts receivable 85 70 40 Merchandise inventory 120 85 60 Paid-in capital...
The revenue R (in millions of dollars) for a company from 2003 through 2016 can be...
The revenue R (in millions of dollars) for a company from 2003 through 2016 can be modeled by R = 6.211t3 − 152.89t2 + 990.1t − 414,    3 ≤ t ≤ 16 where t represents the year, with t = 3 corresponding to 2003. (a) Use a graphing utility to approximate any relative extrema of the model over its domain. (Round each value to two decimal places.) Relative maximum: (t,R)= Relative minimum: (t,R)= (b) Use the graphing utility to approximate the...
Problem 2: (Revised 6.3) Magazine Advertising: In a study of revenue from advertising, data were collected...
Problem 2: (Revised 6.3) Magazine Advertising: In a study of revenue from advertising, data were collected for 41 magazines list as follows. The variables observed are number of pages of advertising and advertising revenue. The names of the magazines are listed as: (use sas） Adv Revenue 25 50 15 49.7 20 34 17 30.7 23 27 17 26.3 14 24.6 22 16.9 12 16.7 15 14.6 8 13.8 7 13.2 9 13.1 12 10.6 1 8.8 6 8.7 12 8.5...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT