Number of equipment sales and service contracts

Assignment Help Finance Basics
Reference no: EM131081350

Would you please explain how to formulate this on an excel spreadsheet. and explain how the results were arrived.

Suppose the number of equipment sales and service contracts that a store sold during the last six (6) months for treadmills and exercise bikes was as follows:

  • Treadmill Exercise Bike
  • Total sold 185 123
  • Service contracts 67 55
  • The store can only sell a service contract on a new piece of equipment. Of the 185 treadmills sold, 67 included a service contract and 118 did not.

Complete the following questions in the space provided below:

  1. Construct a 95 percent confidence interval for the difference between the proportions of service contracts sold on treadmills versus exercise bikes.
  2. Is there a major difference between the two pieces of equipment? Why or why not?

Reference no: EM131081350

Questions Cloud

Design a silicon semiconductor resistor : I. Design a silicon semiconductor resistor. with resistance between 6-10 kn. in the shape of a recungular bar. Assume this resistor will be used in an integrated circuit and therefore a small size is necessary as well as operation.
Central limit theorem : The weights of all NHL goalies are not normally distributed with a mean of 183.5 pounds & standard deviation of 8.8 pounds. A sample of 36 goalies are weighed, calculate the probability that the sample's mean weight is between 185.0 and 186.0 poun..
Average cost of bypass surgery : Is this sufficient evidence to say that the average cost of angioplasty is less than the average cost of bypass surgery?
Null and alternative hypotheses for a nonparametric : The VP of Sales at WidgeCorp, who is comfortable with statistics, wants to know the possible null and alternative hypotheses for a nonparametric test on this data using the chi-square distribution.
Number of equipment sales and service contracts : Suppose the number of equipment sales and service contracts that a store sold during the last six (6) months for treadmills and exercise bikes was as follows:
How data is displayed in the figure or table you selected : Review the Learning Resources for this week related to frequency distributions and graphic displays of data. Using the SPSS software, open the General Social Survey dataset found in this week's Learning Resources.
Evaluation of carcinogenic risks to humans : According to IARC Monographs on the Evaluation of Carcinogenic Risks to Humans: Tobacco smoke and involuntary smoking (Vol. 83. 2004, Lyon: IARC Press), people with the highest lung cancer risks are those who:
Differences in the proportion of young women : Give a 99% confidence interval for the differences in the proportion of young women who develop cervical cancer with and without the vaccine.
Write an essay about the case a political aspect : Write an essay about the case "A Political Aspect". Required "Financial statements must provide a neutral scorecard of the effects of transactions." Comment.

Reviews

Write a Review

Finance Basics Questions & Answers

  What is the forward price

A stock is expected to pay a dividend of $2.20 per share in 1 months and in 4 months. The stock price is $54, and the risk-free interest rate is 11% per annum with continuous compounding for all maturities. An investor has just taken a long position ..

  Present value rigorous federal drug administration testing

Computation of Present value and the process had yet to pass rigorous Federal Drug Administration testing and was still in the early stages of development

  What should the coupon rate be on the new bonds

The company currently has 11 percent bonds on the market that sell for $1,459.51, make semiannual payments, and mature in 18 years. What should the coupon rate be on the new bonds if the firm wants to sell them at par?

  Which of the following features would increase the value of

which of the following features would increase the value of a corporate bond? which would reduce its value?a. the

  Analysts estimate the market risk premium

The earnings, dividends, and common stock price of Shelby Inc. are expected to grow at 4% per year in the future. Shelby's common stock sells for $20.50 per share, its last dividend was $2.00, and the company will pay a dividend of $2.08 at the en..

  Computation of foreign currency - hedging with forward

computation of foreign currency - hedging with forward contracts.a u.s. firm holds an asset in france and faces the

  Qm industries weighted average cost of capital

The target capital structure of QM Industries is 41% common stock, 8%preferred stock, and 51% debt.

  Construct simple cash flow statement and payback calculation

It may surprise you that there are cash flows associated with holding a job. Construct a simple cash flow statement and payback calculation for when your job expenses will be covered for employment you currently have or have had in the past

  What is the average temperature

What is the average temperature (in degrees Celsius) of the coffee during the first half hour?

  Why do businesses operate internationally

Why do businesses operate internationally, and what different types of businesses tend to operate in the international environment? Why are the techniques and strategies available to these firms different?

  New jersey water co njwc is considering whether to refund a

new jersey water co njwc is considering whether to refund a 50 million 14 coupon 30-year bond issue that was sold 5

  What will be the nominal rate of return on a perpetual

What will be the nominal rate of return on a perpetual preferred stock with a $100 par value, a stated dividend of 10% of par, and a current market price of (a) $56.00, (b) $89.00, (c) $107.00, and (d) $131.00? Round answers to the nearest hundred..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd