The data show systolic and diastolic blood pressure of certain people. Find the regression​ equation, letting the systolic reading be the independent​ (x) variable. Find the best predicted diastolic pressure for a person with a systolic reading of 150. Is the predicted value close to 66.2​, which was the actual diastolic​ reading? Use a significance level of 0.05.
Systolic
139
118
145
133
141
138
139
136
  
Diastolic
101
61
82
74
104
79
74
74
LOADING... Click the icon to view the critical values of the Pearson correlation coefficient r.

Refer to the accompanying data set and construct a 95​% confidence interval estimate of the mean pulse rate of adult​ females; then do the same for adult males. Compare the results.

Males Females

84       78

71       95

49       56

63       64

53       54

61       82

51       81

75       88

54       89

62       57

69       36

59       65

62       86

78       74

80       75

65       64

65       68

94       77

45       61

86       61

71       82

63       83

74       68

74       71

54       84

68       90

56       87

77       89

71       91

66       91

63       71

93       91

57       80

63       79

56       74

57       56

71       101

69       76

81       78

56       75

• On January 1, 2006 the Excel Delivery Company purchased a delivery van for $65,000.
• Useful life is 5 years and it has a salvage value of $15,000
• The company expects to drive the van 125,000 miles
• The following is the actual miles driven
  • 2006 – 40,000 miles
  • 2007 – 35,000 miles
  • 2008 – 25,000 miles
  • 2009 – 21,000 miles
  • 2010 – 11,000 miles

Required – Calculate annual depreciation for the five year life of the van using each of the following methods – (round to nearest dollar):

• Straight line
• Sum of the years digits
• Double declining method
• Units of production using miles driven

imagine a small business that you would like to open (Gym). Give a comprehensive overview of the opportunities and challenges facing the business. This might include (but not limited to) discussions of your business's customers, revenue sources, business model, competition, operating environment, marketing efforts, information technology, management structure, etc., etc. s. Be creative. Be concise.

Please finish the following assignment in Excel.

1. Ignoring price, create a chart that displays the seasonality of cranberry sales.
2. Ignoring price, create a chart that shows whether there is an upward trend in sales.
3. Determine average sales per quarter, breaking it down based on whether your price was higher or lower than the competitor’s price. You can use the following function to transform the price into a category variable:  “=IF(J14<K14,"Higher Price", "Lower Price")”

          Suppose 2007 sales are projected to increase by 12.5 percent over 2006 sales. Determine the additional funds needed. Assume that the company was operating with plenty of excess capacity in 2006, that it cannot sell off any of its fixed assets, and that any required financing will be borrowed as notes payable. Also, assume that assets, spontaneous liabilities, and operating costs are expected to increase by the same percentage as sales. Use the percent of sales method to develop a pro forma balance sheet and income statement for December 31, 2007. Use an interest rate of 8 percent on the balance of debt at the beginning of the year to compute interest (cash pays no interest). Use the pro forma income statements to determine the addition to retained earnings.

The amount of time that customers stay in a certain restaurant for lunch is normally distributed with a standard deviation of 14 minutes. A random sample of 15 lunch customers was taken at this restaurant. Construct a 99%confidence interval for the true average amount of time customers spend in the restaurant for lunch. Round your answers to three decimal places and use ascending order.

time 36, 79, 55, 42, 80, 44, 98, 10, 69, 84, 59, 43, 55, 65, 55

Excess revenue (total revenue minus operating expenditures) in the nonprofit sector are normally distributed with a mean of $1.5 million and a standard deviation of $1 million.

(a) What is the probability that a randomly selected nonprofit has negative excess revenues?

(b) What is the probability that a randomly selected nonprofit has excess revenue between $1 million and $2 million?

(c) If 10% of nonprofits are expected to exceed a certain excess revenue level, what is that revenue level?

Determine the effect of the following errors on a company's total revenue, total expenses, and net income. Indicate the effect by selecting Overstated (too much), Understated (too little),or Not Affected.