I want to know how to solve the following in excel. What is the x value and what is the Y value using the data table below?

Wal-Mart is the second largest retailer in the world. The data file (Wal-Mart Revenue 2004-2009.xlsx) is posted below the case study one file, and it holds monthly data on Wal-Mart’s revenue, along with several possibly related economic variables.

A. Develop a linear regression model to predict Wal-Mart revenue, using CPI as the only independent variable.

B. Develop a linear regression model to predict Wal-Mart revenue, using Personal Consumption as the only independent variable.

C. Develop a linear regression model to predict Wal-Mart revenue, using Retail Sales Index as the only independent variable.

D. Which of these three models is the best? Use R-square values, Significance F values, p-values and other appropriate criteria to explain your answer.

E. Generate a scatter plot, residual plot and normal probability plot for the best model in part (d) and comment on what you see.

(c) Does it seem that Wal-Mart’s revenue is closely related to the general state of the economy?

Identify and remove the six cases corresponding to December revenue.

(f) Does it seem that Wal-Mart’s revenue is closely related to the general state of the economy? Use all plots and statistical criteria on the Excel Regression output to explain it. (g) Compare the results of parts (a) and (d), which of these two models is better? Use R-square values, adjusted R-square values, Significance F values, p-values, scatter plots, residual plots and normal probability plots to explain your answer.

ACTIVITY 2

Use the information below to calculate the CPI and inflation rate

Basket                  8 pair of shoes                  4 oil changes

Compute the cost of the basket of goods.

Calculate the CPI use 2003 as the base year.

Calculate the inflation rate use beginning with the inflation rate between 2003 and 2004

Use the information below to calculate the CPI and the Inflation rate

Basket                  10 DVDs                             6 gallons of Milk

Compute the cost of the basket of goods

Calculate the CPI use 2004 as the base year.

Calculate the inflation rate beginning with the inflation rate between 2004 and 2005

Suppose a local news anchorperson in 1960 made $30,000 and the price level in 1960 was 45. Today’s price level is 210. What is the 1960’s local news anchorperson salary worth in today’s dollars.(This is similar to the Babe Ruth example in the notes

Suppose the nominal interest rate is 14% and the inflation rate is 5%. What is the real interest rate?

Suppose the real interest rate is 7% and the inflation rate is 6%. What is the nominal interest rate?

Scores turned in by an amateur golfer at the Bonita Fairways Golf Course in Bonita Springs, Florida, during 2005 and 2006 are as follows: 2005 Season 73 77 78 76 74 72 74 76 2006 Season 70 69 74 76 84 79 70 78 Calculate the mean (0 decimals) and the standard deviation (to 2 decimals) of the golfer's scores, for both years. 2005 Mean Standard deviation 2006 Mean Standard deviation What is the primary difference in performance between 2005 and 2006? What improvement, if any, can be seen in the 2006 scores?

1. Define the term skewness and kurtosis. With the aid of a diagram, describe the three types of kurtosis.            4marks
2. Describe the components of a time series and mention their applicability. 4marks

3. The table below relates to the sales of refrigerators by a certain firm in Kenya.

Year production in (000) Year Production in (000)

1996 17    2002 35

1997 20 2003   55

1998 19 2004 50

1999 26 2005 74

2000 24 2006 69

2001 40

Using this data;

1. Fit a straight line trend by the method of ordinary least squares
2. ii. Estimate the number of refrigerators that will be sold in the year 2009.

1. There are three columns of data: a monthly date, a closing price for an individual stock, and the market close.
   1. Calculate a monthly return series from the closing monthly prices of both the market and the individual security.
   2. Calculate the arithmetic mean return and the standard deviation of the monthly return for both series.
   3. Calculate the geometric mean return for both series.
   4. Calculate the beta of the individual security.

Date   Closing Price   Market Closing Price   Security Return   Market Return
12/1/2003   43.73   1111.92      
1/1/2004   42.43   1131.13      
2/1/2004   43.05   1144.94      
3/1/2004   43.56   1126.21      
4/1/2004   43.8   1107.3      
5/1/2004   44.47   1120.68      
6/1/2004   43.93   1140.84      
7/1/2004   38.17   1101.72      
8/1/2004   38.91   1104.24      
9/1/2004   35.06   1114.58      
10/1/2004   35.59   1130.2      
11/1/2004   34.63   1173.82      
12/1/2004   36.68   1211.92      
1/1/2005   36.55   1181.27      
2/1/2005   37.7   1203.6      
3/1/2005   36.95   1180.59      
4/1/2005   38.52   1156.85      
5/1/2005   39.57   1191.5      
6/1/2005   37.26   1191.33      
7/1/2005   39.05   1234.18      
8/1/2005   39.26   1220.33      
9/1/2005   38.79   1228.81      
10/1/2005   38.42   1207.01      
11/1/2005   38.59   1249.48      
12/1/2005   36.44   1248.29      
1/1/2006   37.41   1280.08      
2/1/2006   37.94   1280.66      
3/1/2006   38.13   1294.87      
4/1/2006   38.21   1310.61      
5/1/2006   40.09   1270.09      
6/1/2006   39.46   1270.2      
7/1/2006   40.81   1276.66      
8/1/2006   41.1   1303.82      
9/1/2006   41.26   1335.85      
10/1/2006   43.15   1377.94      
11/1/2006   43.54   1400.63      
12/1/2006   44.86   1418.3      
1/1/2007   44.51   1438.24      
2/1/2007   43.4   1406.82      
3/1/2007   44.94   1420.86      
4/1/2007   48.87   1482.37      
5/1/2007   49.62   1530.62      
6/1/2007   49.31   1503.35      
7/1/2007   49.12   1455.27      
8/1/2007   50.69   1473.99      
9/1/2007   54.5   1526.75      
10/1/2007   58.57   1549.38      
11/1/2007   59.22   1481.14      
12/1/2007   58.52   1468.36      
1/1/2008   56.26   1378.55      
2/1/2008   55.74   1330.63      
3/1/2008   58.42   1322.7      
4/1/2008   56.5   1385.59      
5/1/2008   54.95   1400.38      
6/1/2008   50.21   1280      
7/1/2008   49.75   1267.38      
8/1/2008   50.3   1282.83      
9/1/2008   51.45   1164.74      
10/1/2008   42.86   968.75      
11/1/2008   45.99   896.24      
12/1/2008   44.42   903.25      
              
Arithmetic mean              
Geometric mean               
Standard deviation              
              
Covariance              
Beta              

Shown here are Caterpillar's annual global sales and revenue streams for the years 2004 through 2014. By observing the data graphically and analyzing the data statistically using techniques and concepts from this chapter (forecasting trend line, etc.), share your insights and conclusions about Caterpillar's annual global sales and revenue streams over this period of time.

Problem 1 At a local supermarket, customers spend an average of 74 AED. The standard deviation is 30 AED. If 60 customers come to the supermarket today, what is the probability that the total revenue of the supermarket will be between 4000 AED and 5000 AED.

Compute and Interpret Liquidity, Solvency and Coverage Ratios
Selected balance sheet and income statement information for Calpine Corporation for 2004 and 2006 follows.

(a) Compute the following liquidity, solvency and coverage ratios for both years. (Round your answers to two decimal places.)
2006 current ratio = Answer
2004 current ratio = Answer

2006 quick ratio = Answer
2004 quick ratio = Answer

2006 liabilities-to-equity = Answer
2004 liabilities-to-equity = Answer

2006 total debt-to-equity = Answer
2004 total debt-to-equity = Answer

2006 times interest earned = Answer
2004 times interest earned = Answer

2006 cash from operations to total debt = Answer
2004 cash from operations to total debt = Answer

2006 free operating cash flow to total debt = Answer
2004 free operating cash flow to total debt = Answer

(b) Which of the following best describes the company's credit risk?

Both the quick ratio and current ratio for 2006 are lower than 1.0 and have increased in the past two years. Along with interest coverage ratios that are exceedingly high, the probability that the company will face default has significantly increased.

Both the quick ratio and current ratio for 2006 are lower than 1.0 and have decreased in the past two years. Along with interest coverage ratios that are exceedingly low, the probability that the company will face default has significantly increased.

Both the quick ratio and current ratio for 2006 are above 1.0 and have decreased in the past two years. Along with interest coverage ratios that are exceedingly low, the probability that the company will face default has significantly decreased.

Both the quick ratio and current ratio for 2006 are above 1.0 and have increased in the past two years. Along with interest coverage ratios that are exceedingly high, the probability that the company will face default has significantly decreased.