The polling organization Ipsos conducted telephone surveys in March of 2004, 2005 and 2006. In each year, 1001 people age 18 or older were asked about whether they planned to use a credit card to pay federal income taxes that year. The data are given in the accompanying table. Is there evidence that the proportion falling in the three credit card response categories is not the same for all three years? Test the relevant hypotheses using a .05 significance level. (Use 2 decimal places.)
| Intent to Pay Taxes with a Credit Card | |||
| 2004 | 2005 | 2006 | |
| Definitely/Probably Will Might/Might Not/Probably Not Definitely Not |
42 163 782 |
45 180 777 |
42 190 780 |
χ2 =
P-value interval
p < 0.0010.001 ≤ p < 0.01 0.01 ≤ p < 0.050.05 ≤ p < 0.10p ≥ 0.10
In: Math
Assume you are doing a financial analysis for Kroger Inc. Here is one of the income statements that you analyze (all figures in $ Millions):
| year | 2006 | 2005 | 2004 | |||||||||||
| total sales | 60,553 | 56,434 | 53,791 | |||||||||||
| cost of goods sold | 45,565 | 42,140 | 39,637 | |||||||||||
| seeling, general &admin expenses | 11,688 | 12,191 | 11,575 | |||||||||||
| depreciation | 1,265 | 1,256 | 1,209 | |||||||||||
| operating income | 2,035 | 847 | 1,370 | |||||||||||
| other income | 0 | 0 | 0 | |||||||||||
| ebit | 2,035 | 847 | 1,370 | |||||||||||
| interest expense | 510 | 557 | 604 | |||||||||||
| earnings before tax | 1,525 | 290 | 766 | |||||||||||
| taxes (35%) | 534 | 102 | 268 | |||||||||||
| net income | 991 | 189 |
498 |
Based on your analysis of the income statements. What can be said about the progress. Which areas are improving? Sales increased from 2004 to 2005 yet net profit decreased . Why do you think they decreased net income in 2005 with higher sales. sales? 2006 seems to be better. What did the fix?
In: Finance
American customer satisfaction index: Starbucks in the U.S. 2006-2016
|
2006 |
77 |
|
2007 |
78 |
|
2008 |
77 |
|
2009 |
76 |
|
2010 |
78 |
|
2011 |
80 |
|
2012 |
76 |
|
2013 |
80 |
|
2014 |
76 |
|
2015 |
74 |
|
2016 |
75 |
ABOUT THIS STATISTIC: This statistic shows the American customer satisfaction index scores of Starbucks in the United States from 2006 to 2016. Starbucks had an ACSI score of 75 in 2016.
Starbucks
The Starbucks Corporation is a coffeehouse chain based in Seattle which operates more than 25 thousand stores worldwide (as of 2016). Just over 50 percent (around 7,880) of all Starbucks stores were company-operated stores, from which Starbucks generates around 79 percent of its revenue. Around 5,292 stores are licensed stores. Starbucks, which became a publicly traded company on June 26, 1992, generated around 21.32 billion U.S. dollars in revenue in the 2016 fiscal year.
In its company-operated stores Starbucks generates 74 percent of revenue from the sale of beverages, 19 percent from food sales and three percent from the sale of packaged and single serve coffees. Another four percent of retail sales are attributable to coffee-making equipment and other merchandise.
The United States is Starbucks’ biggest and most important market. In 2016, revenues from Starbucks Americas segment amounted to more than 14 billion U.S. dollars. The
Americas segment comprises over 13,000 stores in the U.S., Canada, Mexico, Puerto Rico, Brazil Chile and other American countries with around 86 percent of those stores located in the United States. 2
20) Draw the trendline in excel. Can the regression line be used for prediction? No, it is too weak. Insert excel graph here:
In: Statistics and Probability
Open Air_Traffic data. SETUP: It is believed that in July, as years go by we see higher and higher traffic. Given the data your job is to confirm or disprove this assertion.
4. What test/procedure did you perform? (4 points)
5. What is the statistical interpretation? (4 points)
6. What is the conclusion? (4 points)
| month | year | Air Traffic |
| Sep | 2001 | 527,483 |
| Feb | 1998 | 545,512 |
| Feb | 1997 | 560,142 |
| Nov | 2001 | 562,761 |
| Feb | 1999 | 568,516 |
| Nov | 1997 | 571,222 |
| Feb | 2002 | 571,898 |
| Jan | 1998 | 573,195 |
| Sep | 1998 | 574,779 |
| Apr | 1998 | 577,213 |
| Feb | 1996 | 578,736 |
| Dec | 2001 | 580,757 |
| Nov | 1996 | 584,295 |
| Oct | 2001 | 588,116 |
| Sep | 1997 | 588,745 |
| Dec | 1997 | 591,915 |
| Jan | 1996 | 593,346 |
| Jan | 1999 | 595,134 |
| Sep | 1996 | 595,394 |
| Nov | 1998 | 601,849 |
| Jun | 1998 | 602,622 |
| Jan | 1997 | 604,399 |
| Jun | 1996 | 605,753 |
| Apr | 1997 | 605,797 |
| Feb | 2000 | 605,799 |
| Dec | 1996 | 606,229 |
| Apr | 1996 | 606,312 |
| Oct | 1997 | 606,522 |
| Feb | 2013 | 607,481 |
| Mar | 1998 | 608,740 |
| May | 1998 | 610,593 |
| Jul | 1997 | 611,722 |
| Jan | 2002 | 614,110 |
| Feb | 2001 | 614,242 |
| Jun | 1997 | 614,943 |
| Aug | 1997 | 619,541 |
| May | 1996 | 619,734 |
| Dec | 1998 | 619,871 |
| Oct | 1996 | 620,810 |
| Sep | 1999 | 621,236 |
| Apr | 1999 | 622,759 |
| Feb | 2010 | 623,022 |
| May | 1997 | 623,488 |
| Jul | 1996 | 623,594 |
| Jan | 2000 | 623,646 |
| Mar | 1997 | 624,222 |
| Feb | 2011 | 625,559 |
| Apr | 2002 | 626,683 |
| Mar | 1996 | 626,722 |
| Sep | 2002 | 626,950 |
| Nov | 1999 | 627,298 |
| Aug | 1996 | 628,524 |
| Oct | 1998 | 629,926 |
| Aug | 1998 | 632,272 |
| Jun | 1999 | 633,058 |
| May | 1999 | 634,994 |
| Apr | 2000 | 635,683 |
| Jul | 1998 | 636,816 |
| Mar | 2002 | 639,968 |
| May | 2002 | 640,659 |
| Mar | 1999 | 641,159 |
| Jun | 2002 | 642,274 |
| Dec | 1999 | 646,562 |
| Dec | 2000 | 646,562 |
| Feb | 2012 | 647,034 |
| Nov | 2013 | 652,027 |
| Apr | 2001 | 652,922 |
| Jul | 1999 | 654,104 |
| Oct | 1999 | 655,244 |
| Jun | 2001 | 655,886 |
| Nov | 2000 | 657,575 |
| Sep | 2000 | 658,274 |
| Feb | 2009 | 659,905 |
| Jun | 2000 | 660,467 |
| Jan | 2013 | 661,969 |
| Aug | 1999 | 663,927 |
| Mar | 2000 | 666,940 |
| Nov | 2012 | 669,426 |
| Dec | 2012 | 670,923 |
| May | 2000 | 672,620 |
| Jul | 2002 | 673,615 |
| May | 2001 | 674,360 |
| Jan | 2012 | 677,716 |
| Jan | 2001 | 677,941 |
| Sep | 2012 | 678,037 |
| Aug | 2002 | 679,840 |
| Sep | 2013 | 680,200 |
| Jan | 2011 | 681,174 |
| Jul | 2000 | 682,558 |
| Nov | 2011 | 682,682 |
| Mar | 2001 | 683,033 |
| Feb | 2003 | 690,351 |
| Apr | 2013 | 692,634 |
| Oct | 2000 | 692,862 |
| Aug | 2000 | 692,874 |
| Jul | 2001 | 693,672 |
| Oct | 2012 | 694,760 |
| Nov | 2009 | 694,780 |
| Jan | 2010 | 694,866 |
| Dec | 2011 | 701,368 |
| Dec | 2010 | 702,620 |
| Oct | 2013 | 702,901 |
| Nov | 2010 | 704,414 |
| Dec | 2009 | 704,870 |
| Sep | 2011 | 706,423 |
| Apr | 2012 | 707,046 |
| Aug | 2001 | 707,077 |
| Nov | 2008 | 707,252 |
| Sep | 2009 | 709,839 |
| Jan | 2009 | 709,936 |
| Mar | 2013 | 710,186 |
| Feb | 2006 | 715,843 |
| Sep | 2010 | 718,697 |
| Jun | 2013 | 719,059 |
| Dec | 2008 | 720,064 |
| Apr | 2011 | 720,117 |
| May | 2013 | 721,141 |
| Apr | 2010 | 722,593 |
| Oct | 2011 | 723,246 |
| Feb | 2007 | 724,657 |
| May | 2012 | 725,746 |
| Oct | 2009 | 726,611 |
| Sep | 2008 | 728,389 |
| Mar | 2012 | 728,653 |
| Apr | 2009 | 728,892 |
| Jun | 2012 | 735,119 |
| Oct | 2010 | 737,265 |
| Mar | 2010 | 739,935 |
| May | 2010 | 741,616 |
| May | 2011 | 743,824 |
| Feb | 2008 | 746,679 |
| Aug | 2013 | 747,008 |
| Mar | 2009 | 747,367 |
| May | 2009 | 749,038 |
| Jul | 2013 | 750,776 |
| Jun | 2010 | 751,359 |
| Aug | 2012 | 753,513 |
| Mar | 2011 | 754,694 |
| Jun | 2011 | 756,735 |
| Jul | 2012 | 757,513 |
| Oct | 2008 | 758,540 |
| Jun | 2009 | 760,198 |
| Feb | 2005 | 760,955 |
| Feb | 2004 | 761,618 |
| Nov | 2003 | 765,842 |
| Apr | 2003 | 766,260 |
| Nov | 2002 | 766,327 |
| Aug | 2011 | 767,983 |
| Aug | 2009 | 781,361 |
| Aug | 2010 | 781,460 |
| Dec | 2002 | 781,653 |
| Sep | 2003 | 781,804 |
| Jul | 2010 | 782,506 |
| Jul | 2011 | 783,853 |
| Jan | 2003 | 785,160 |
| Jan | 2006 | 785,364 |
| Jan | 2004 | 787,237 |
| May | 2003 | 789,397 |
| Nov | 2006 | 792,523 |
| Jan | 2008 | 793,275 |
| Jul | 2009 | 794,077 |
| Apr | 2006 | 794,390 |
| Mar | 2003 | 797,194 |
| Nov | 2005 | 797,460 |
| Jun | 2003 | 798,351 |
| Dec | 2003 | 798,392 |
| Apr | 2008 | 799,666 |
| Sep | 2006 | 799,777 |
| Dec | 2005 | 802,067 |
| Jan | 2007 | 803,924 |
| Dec | 2007 | 803,981 |
| Nov | 2007 | 804,635 |
| Dec | 2006 | 805,058 |
| Sep | 2007 | 805,076 |
| Jan | 2005 | 807,338 |
| Apr | 2007 | 809,663 |
| Sep | 2005 | 814,935 |
| Oct | 2002 | 815,032 |
| Jun | 2008 | 815,936 |
| Mar | 2008 | 817,511 |
| Apr | 2004 | 817,899 |
| Oct | 2003 | 818,308 |
| Sep | 2004 | 819,294 |
| Nov | 2004 | 820,048 |
| May | 2008 | 820,130 |
| Jun | 2006 | 820,310 |
| Aug | 2008 | 823,531 |
| Mar | 2006 | 823,793 |
| May | 2006 | 824,051 |
| Oct | 2006 | 828,218 |
| Mar | 2007 | 830,373 |
| Aug | 2003 | 830,737 |
| Oct | 2005 | 831,265 |
| Jul | 2003 | 831,619 |
| Jun | 2007 | 832,163 |
| May | 2004 | 833,350 |
| Mar | 2004 | 834,476 |
| Dec | 2004 | 836,232 |
| Jun | 2004 | 836,916 |
| Apr | 2005 | 838,122 |
| Oct | 2007 | 841,179 |
| May | 2007 | 844,074 |
| Jul | 2008 | 844,755 |
| Jul | 2006 | 852,114 |
| Oct | 2004 | 861,291 |
| Jun | 2005 | 863,422 |
| Jul | 2007 | 863,659 |
| Aug | 2006 | 866,551 |
| Mar | 2005 | 866,593 |
| Jul | 2004 | 871,049 |
| Aug | 2007 | 872,349 |
| May | 2005 | 872,961 |
| Aug | 2004 | 882,979 |
| Jul | 2005 | 887,084 |
| Aug | 2005 | 890,938 |
In: Statistics and Probability
Rozo company carries the following investments on its books at December 31, 2005, and December 31, 2006. All securities were purchased during 2005.
Trading Securities:
| Company | Cost | Value December 31, 2005 | Value December 31, 2006 |
| A Company | $25,000 | $13,000 | $20,000 |
| B Company | $13,000 | $20,000 | $20,000 |
| C Company | $35,000 | $30,000 | $25,000 |
Available for Sale Securities:
| Company | Cost | Value December 31, 2005 | Value December 31, 2006 |
| X Company | $210,000 | $130,000 | $50,000 |
| Y Company | $50,000 | $60,000 | $70,000 |
A. Prepare the necessary journal entries for Rozo company on December 31, 2005, and December 31,2006.B. What net effect would the valuation of these stock investments have on 2005 net income?On 2006 net income?
In: Accounting
The polling organization Ipsos conducted telephone surveys in March of 2004, 2005 and 2006. In each year, 1001 people age 18 or older were asked about whether they planned to use a credit card to pay federal income taxes that year. The data are given in the accompanying table. Is there evidence that the proportion falling in the three credit card response categories is not the same for all three years? Test the relevant hypotheses using a .05 significance level. (Use 2 decimal places.)
| Intent to Pay Taxes with a Credit Card | |||
| 2004 | 2005 | 2006 | |
| Definitely/Probably Will Might/Might Not/Probably Not Definitely Not |
45 175 761 |
43 169 798 |
43 168 767 |
χ2 =
P-value interval
p < 0.001
0.001 ≤ p < 0.01
0.01 ≤ p < 0.05
0.05 ≤ p < 0.10
p ≥ 0.10
In: Statistics and Probability
The polling organization Ipsos conducted telephone surveys in March of 2004, 2005 and 2006. In each year, 1001 people age 18 or older were asked about whether they planned to use a credit card to pay federal income taxes that year. The data are given in the accompanying table. Is there evidence that the proportion falling in the three credit card response categories is not the same for all three years? Test the relevant hypotheses using a .05 significance level. (Use 2 decimal places.) Intent to Pay Taxes with a Credit Card 2004 2005 2006 Definitely/Probably Will Might/Might Not/Probably Not Definitely Not 46 172 791 47 173 761 49 182 800 χ2 = P-value interval p < 0.001 0.001 ≤ p < 0.01 0.01 ≤ p < 0.05 0.05 ≤ p < 0.10 p ≥ 0.10
In: Statistics and Probability
Let’s examine the history of LSUS undergraduate enrollment vs. its tuition and fees. Download the “A3Q1 LSUS enrollment data” Excel file (in CSV format if you don’t have Excel); in it you will see historical information on LSUS undergraduate enrollment, total credit hour production, and tuition and fees. (If you wish, you can verify or look up additional information here, here, and here.)
Calculate annual elasticities for both types of quantity variables (i.e., you will have an elasticity of price vs. headcount, and one of price vs. credit hour). You will get an error message in your calculations when the tuition doesn't change from 2006-2007 and 2016-2017, since the elasticity calculation will be trying to divide by zero; just delete those error values in your Excel table so that the cells are blank. The first headcount elasticity will be calculated based on the 2004 and 2005 values of tuition and headcount and should be about 0.159; the first credit hour elasticity will also be based on the 2004 and 2005 values and should be about -0.348). Calculate the average annual elasticity for headcount (from 2004-2017), and the average annual elasticity for credit hour (from 2004-2017).
Many administrators argue that, to increase revenue to LSUS to cover budget shortfalls, tuition should be raised. Comment on this suggestion, using the evidence you’ve uncovered.
| Year | undergrad enrollment | total LSUS credit hour production | undergrad tuition and fees | ||
| 2004 | 3,910 | 101,868 | $1,545 | ||
| 2005 | 3,940 | 100,181 | $1,621 | ||
| 2006 | 3,594 | 92,486 | $1,667 | ||
| 2007 | 3,556 | 92,123 | $1,667 | ||
| 2008 | 3,903 | 94,639 | $1,751 | ||
| 2009 | 4,220 | 101,972 | $1,867 | ||
| 2010 | 4,058 | 98,137 | $2,062 | ||
| 2011 | 4,134 | 98,372 | $2,247 | ||
| 2012 | 4,124 | 93,163 | $2,472 | ||
| 2013 | 3,674 | 85,292 | $2,803 | ||
| 2014 | 3,202 | 87,907 | $3,084 | ||
| 2015 | 2,775 | 91,021 | $3,355 | ||
| 2016 | 2,587 | 94,077 | $3,417 | ||
| 2017 | 2,637 | 115,340 | $3,417 | ||
In: Economics
Listed below is the number of movie tickets sold at the Library Cinema-Complex, in thousands, for the period from 2004 to 2016. Compute a five-year weighted moving average using weights of 0.1, 0.1, 0.2, 0.3, and 0.3, respectively. Describe the trend in yield. (Round your answers to 3 decimal places.)
| 2004 | 8.61 | |
| 2005 | 8.14 | |
| 2006 | 7.67 | |
| 2007 | 6.59 | |
| 2008 | 7.37 | |
| 2009 | 6.88 | |
| 2010 | 6.71 | |
| 2011 | 6.61 | |
| 2012 | 5.58 | |
| 2013 | 5.87 | |
| 2014 | 5.94 | |
| 2015 | 5.49 | |
| 2016 | 5.43 | |
The weighted moving averages are:
In: Statistics and Probability
using chapter 13 data set 2, the researchers want to find out whether there is a difference among the graduation rates (and these are percentages) of five high schools over a 10-year period. Is there? (hint: are the years a factor?)
| High School 1 | High School 2 | High School 3 | High School 4 | High School 5 | |
| 2003 | 67 | 82 | 94 | 65 | 88 |
| 2004 | 68 | 87 | 78 | 65 | 87 |
| 2005 | 65 | 83 | 81 | 45 | 86 |
| 2006 | 68 | 73 | 76 | 57 | 88 |
| 2007 | 67 | 77 | 75 | 68 | 89 |
| 2008 | 71 | 74 | 81 | 76 | 87 |
| 2009 | 78 | 76 | 79 | 77 | 81 |
| 2010 | 76 | 78 | 89 | 72 | 78 |
| 2011 | 72 | 76 | 76 | 69 | 89 |
| 2012 | 77 | 86 | 77 | 58 | 87 |
In: Math