The data from Exhibit 3 is also in the Excel file income.xls on the course website. Use Excel, along with this file, to determine Mrs. Bella’s real income for the last fifteen years. Do this by first converting each price index from percent by dividing by 100. Then, divide gross income by your converted (adjusted) price index. Using Excel, find the mean, median, standard deviation, and variance of her past real income. Explain the meaning of these statistics. Can you use mean income to forecast future earnings? Take into account both statistical and non-statistical considerations.

Patient History

History: PAD (2004); Arterial Ulcer (2020); Smoker since 1990

Complaints: Pain to left foot and difficulty walking

•Based on the history and complaints, which body system (s) is/are being compromised?*

3 Nursing Diagnoses

3 Nursing Interventions

3 Patient Intervention

You are to examine the expected return and risk (standard deviation) of a two security portfolio. Your portfolio consists of the stock of Wolf Creek Company (WCC) and the stock of RHC Industrial. The two companies’ stocks have the following stock prices over the past 10 years, and they do not pay dividends.

WCC ($)                                   RHC ($)

2006                                                    45                                            18

2007                                                    49                                            19

2008                                                    44                                            21

2009                                                    58                                            25

2010                                                    55                                            27

2011                                                    46                                            25

2012                                                    68                                            33

2013                                                    75                                            34

2014                                                    79                                            39

2015                                                    84                                            34

2016                                                    98                                            42

2017                                                    115                                          43

2018                                                    112                                          49

2019                                                    135                                          48

(A – 13 points) calculate the annual holding period returns for each stock.

(B – 10 points ) calculate the average holding period return, the standard deviation of returns for each stock, and the correlation coefficient between the two stocks. You may use the statistical functions in Excel.

Please show all formulas so i can replicate in excel

1. In May 2004, a Gallup Poll of adults’ attitudes toward Health Maintenance Organizations (HMOs) found that 40% of adults had little or no confidence in HMOs, 39% had some confidence, 18% had a great deal of confidence, and 3% had no opinion (USA Today, June 22, 2004). The letters L, S, G, and N will be used to denote these percentages. A recent random sample of 500 adults gave the following distribution of responses.

   L         S     G N

212 198   82 8 Total 500

Perform a Chi Square test using the .01 significance to test the hypothesis (Ho): The current distribution of adults’ attitudes toward HMOs is the same as that of 2004.

a. Find the Critical value (table Value) for Chi square

b. Calculate the Chi Square test statistic for the sample

c. Do you reject or not reject the Ho (Explain what your answer means)

LGF Inc. sells furniture for $16,525. customers can buy a 5 years warranty on this furniture for $5,000 up to 1year after the purchase date of the product.  Furniture and warranty package costs $20,000 for special deal.

On January 1, 2007, the company sold 5 special deal packages. The cost of the furniture sold was $68,000.

The company paid cash of $700 for the cost of meeting the warranty during 2007.

The company recognizes revenue annually on the warranty agreement based on the passage of time.

Under IFRS, what is the journal entries for January 1, 2007 and December 31, 2007?

In a 2-3 page paper, complete the case below and submit to instructor. Review the income statement for Uden Supply Company and answer the following:

Describe the purpose of analytical procedures performed in the planning stage of the audit.
Uden Supply has projected its 2004 gross profit at 31% of sales despite expectation for some shrinkage in margins. On the basis of Uden's operating performance in years 2001 - 2003 project your best guess for 2004. Project 2004 based on the incremental changes for each line item over the last three years.
Uden’s unaudited financial statements for the current year show a 31 percent gross profit rate. Assuming that this represents a misstatement from the amount that you developed as an expectation, calculate the estimated effect of this misstatement on net income before taxes for 20X4.
Indicate whether you believe that the difference calculated in part (c) is material. Explain your answer. (50-100 words).
Comparative income statement information for Uden Supply Company is presented in the accompanying table.

UDEN SUPPLY COMPANY

Comparative Income Statement

Years Ended December 20X1, 20X2, and 20X3

(Thousands)

20X1 Audited 20X2 Audited 20X3 Audited 20X4 Expected

Sales 8,700 9,400 10,100

Cost of goods sold 6,000 6,500 7,000

Gross profit    2,700 2,900 3,100

Sales Commissions 610 660 710

Advertising 175 190 202

Salaries 1,061 1,082 1,103

Payroll taxes 184 192 199

Employee benefits 167 174 181

Rent 60 61 62

Depreciation   60 63 66

Supplies   26 28 30

Utilities 21 22 23

Legal and accounting 34 37 40

Miscellaneous 12 13 14

Interest expense 210 228 240

Net income before taxes 80 150 230

Incomes taxes 18 33 50

Net income 62 117 180

People tend to evaluate the quality of their lives relative to others around them. In a demonstration of this phenomenon, Frieswijk, Buunk, Steverink, and Slaets (2004) conducted fictitious interviews with frail elderly people. In the interview, each person was compared with others who were worse off. After the interviews, the elderly people reported more satisfaction with their own lives (the hypothetical data are reported below). The scores are measures on a life satisfaction scale for a sample of n = 9 elderly people who completed the interview are: 18, 23, 24, 22, 19, 27, 23, 26, 25.

Assume that the average score on this scale is m= 20. Are the data sufficient to conclude that the people in this sample are significantly more satisfied than others in the general population? Use a = .05.

Airlines have increasingly outsourced the maintenance of their planes to other companies. A concern voiced by critics is that the maintenance may be less carefully done so that outsourcing creates a safety hazard. In addition, flight delays are often due to maintenance problems, so one might look at government data on percent of major maintenance outsourced and percent of flight delays blamed on the airline to determine if these concerns are justified. This was done, and data from 2005 and 2006 appeared to justify the concerns of the critics. Do more recent data still support the concerns of the critics? Here are data from 2014:

Make a scatterplot with outsourcing percent as ?x and delay percent as ?.

Find the correlation ?r with and without Hawaiian Airlines. Enter your answers rounded to four decimal places.

Suppose a marketing company wants to determine the current proportion of customers who click on ads on their smartphones. It was estimated that the current proportion of customers who click on ads on their smartphones is 0.39 based on a random sample of 100 customers. Compute a 95% confidence interval for the true proportion of customers who click on ads on their smartphones and fill in the blanks appropriately.

Answer:

___<P<____ (3 decimal Places)

1.Assume that the cost formula for one of a company’s variable expenses is $5.00 per unit. The company’s planned level of activity was 2,000 units and its actual level of activity was 2,200 units. The actual amount of this expense was $10,040. The spending variance for this expense is:

• $960 F.

• $1,560 F.

• $2,520 U.

• $2,520 F

2.Assume the sales budget for April and May is 46,000 units and 48,000 units, respectively. The production budget for the same two months is 43,000 units and 44,000 units, respectively. Each unit of finished goods required 4 pounds of raw materials. The company always maintains raw materials inventory equal to 25% of the following months production needs. If the company pays $2.75 per pound of raw material, then what is the estimated cost of raw material purchases for April?

• $478,750

• $475,750

• $475,000

• $481,500

3.Assume that a company’s budgeted revenue per unit is $50. The company’s planned level of activity was 2,000 units and its actual level of activity was 2,200 units. Its actual revenue was $103,400. The company’s revenue variance is:

• $6,600 U.

• $6,600 F.

• $4,600 F.

• $4,600 U.

4.Assume the sales budget for April and May is 42,000 units and 44,000 units, respectively. The production budget for the same two months is 39,000 units and 40,000 units, respectively. Each unit of finished goods required 4 pounds of raw materials. The company always maintains raw materials inventory equal to 30% of the following month's production needs. How many pounds of raw material need to be purchased in April?

• 159,200

• 157,200

• 156,600

• 161,100

5.Assume a company’s budgeted unit sales and its required production in units for April are 92,000 units and 90,000 units, respectively. The direct labor-hours required per unit is 1.50 hours. The company’s total budgeted direct labor cost for April is $1,957,500. What is the budgeted direct labor wage rate per hour for April?

• $14.50

• $19.07

• $18.40

• $14.18

6.Assume the following (1) sales = $200,000, (2) unit sales = 10,000, (3) the contribution margin ratio = 37%, and (4) net operating income = $10,000. Given these four assumptions, which of the following is true?

• The variable expense per unit = $7.40

• The total fixed expenses = $126,000

• The total contribution margin = $74,000

• The break-even point is 8,077 units

7.Assume that a company’s planned level of activity was 2,000 units and its actual level of activity was 2,100 units. The revenue variance was $1,200 unfavorable and the revenue activity variance was $7,400 unfavorable. What budgeted revenue per unit does the company use for creating its planning and flexible budgets?

• $74 per unit

• $70 per unit

• $64 per unit

• $40 per unit