Simple regression-multiple regression analysis

Assignment Help Biology
Reference no: EM13922679

Simple Regression Analysis.

Use the data in the chart to answer the questions below. The data indicates the number of "sick days" appliance installers take during a three month period, and the number of complaints filed by customers during the same interval. Use the Analysis Toolpak in Excel to perform this simple regression and answer the questions.
a. Is the correlation between number of sick days and number of customer complaints statistically significant?
b. What is the best prediction for the number of complaints that will be registered for an installer who takes five sick days during the period?

Multiple Regression Analysis.

Develop a multiple linear regression equation that describes the relationship between tenure and the other variables in the chart above. Use the Analysis Toolpak located in Excel to perform this multiple regression.
Do these two variables explain a reasonable amount of the variation in the dependent variable?
Estimate the tenure of someone that could have $5.8($k) and 15 years of job satisfaction. Make sure to state your multiple regression equation in your example. What are some of things that you can estimate from the model? How effective is evaluating the R-squared of the model? What is the relationship between the independent and dependent variables?
Use Excel to help you answer the questions in the forum but do not attach your Excel document to the discussion post.
Guided Response: Review several of your classmates' postings. Respond to at least two classmates by commenting on how this information might be used to make business decisions.

Reference no: EM13922679

Questions Cloud

Gauge the relationship between each pair of variables : A courier service in a large city tracks the number of deliveries they are asked to make by 10 clients both before and after offering a progressive discount for repeat business. Their goal is to assess the effects of the discount.
Define capitalism as it relates to us as an economic system : Define Capitalism as it relates to the U. S. as an economic system. What are pros and cons of a Capitalistic economic system such as the U. S.
Inference circumvents logical reasoning : Inferring a claim based on data is deductive logic, but what happens when the inference circumvents logical reasoning?
Pulmonary case presentations : Pulmonary Case Presentations. Please select one case presentation below and provide answers to the following; Three differential diagnoses and Definitive diagnosis
Simple regression-multiple regression analysis : Use the data in the chart to answer the questions below. The data indicates the number of "sick days" appliance installers take during a three month period, and the number of complaints filed by customers during the same interval. Use the Analysis..
Compute the economic order quantity : Prepare a statement of cost of goods manufactured for Widget Company for the year ended December 31, 2011 - Compute the economic order quantity and compute the order size that results in the minimum total order and carrying cost
News due to ethical problems : Research a company that has been in the news due to ethical problems. Evaluate the ethical dilemma under two ethical frameworks. Analyze what part whistleblowers played in the exposure to the company.
Draw the hash table containing the hash structure : We keep inserting 82 and 89 into the hash table. Draw the table to refl the new values. Be sure to indicate the number of bits used during hashing.
Calculate linear regression-correlation between two variable : The manager of a catering company is using the number of people in the party to predict the cost of the drinks that are required for the event. The following are the data for 12 recently catered events:

Reviews

Write a Review

Biology Questions & Answers

  Compare and contrast the effect of a deletion

Compare and contrast the effect of a deletion in the operator of the lactose operon with one in the operator of the tryptophan operon.

  Explore the different types of treatments of prostate cancer

One of the most common cancers in men is prostate cancer. Once detected, there are many different types of treatment available. Using a search engine, explore the different types of treatments available and pick one that you feel would be most e..

  Unpredictable and adultsurvivorship is good

If environmental conditions are very unpredictable and adultsurvivorship is good, reproductive individuals should:

  Find the allele frequencies

White wool is dependent upon a dominant allele B and black woolupon its recessive b. A sample of Rambouill breed in Idaho gave thefollowing data: 891 white and 9 black. Find the allele frequencies.

  What is probability of a human gamete being fully parental

Assume crossing over does not occur. What is the probability of a human gamete being fully parental?

  Determine the membrane potential

Suppose that the proton motive force calculated for a bacterial cell is -187 mV. If the change in pH at 25 degrees Celsius is +0.1 (2.3RT/F or Z=59), Determine the membrane potential?

  Define the terms transcription and translation

Define the terms "transcription" and "translation" and explain how these processes result in the expression of genes

  What are the different types of sugars

What are the different types of sugars? What is the difference between inorganic and organic compounds?

  Autosomal recessive gene transformer mutation

The autosomal recessive gene transformer (tra) mutation converts chromosomal females into sterile males. A female Drosophila that is heterozygous for the tra allele is mated with a normal male homozygous for transformer. What is the sex ratios of the..

  What is mutation rate

Tay Sachs, an autosomal recessive genetic disease in humans has a frequency (q2, assuming random mating) of about 2x10-6; assuming random mating, therefore, the frequency of the Tay-Sachs allele, q is about 1.4x10-3 . Tay-Sachs sufferers usually d..

  Why are the predator and prey growth curves out of phase

In Predator-Prey Model 1, why are the predator and prey growth curves out of phase?

  Explain why modern social scientists

Explain why modern "social scientists" such as anthropologists, economists, psychologists, and sociologists often err in their conclusions about the nature of man and his society.

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