Perform in an assessment of statistical knowledge and skill

Assignment Help Advanced Statistics
Reference no: EM131096354

JSMCase: Along with many other students, prince Mean Chaser, princess Age and princess I-net are students at the college of business at TAMUCC. Often they hold conversations with their dady, King Menalaus of Troy, about their dad's favorite and their hardest subject--business statistics. King Menalaus is well known as a data driven decision maker and he takes pleasure in discovering knowledge about relationships among variables related to students and others who live in his kingdom. King Menalaus and his two daughters and one son had the following conversation recently.

Prince Mean Chaser: The mean score in a business statistics course for all students at TAMUCC is less than 70 out of 100. I am 99% sure about this, Daddy. So, my score of 67 is not all that low.

King Menalaus: I wish I could believe you. Can you help me believe you, Prince Mean Chaser? I think the average performance is 70 or higher out of 100.

Princess Age: The older a student, the better the student performs in an assessment of statistical knowledge and skills. I am only 18 years old, Daddy, and this is why I scored 65% in business statistics. I am not old enough to do any better.

King Menalaus: I will disagree with you on this point, Princess Age, until you support your opinion with data-driven analysis.

Princess I-Net: The more a student uses the Internet, the better the student performs in an assessment of statistical knowledge and skills. Since you allow me to spend only twenty five hours per week on the Internet, I scored only 68 in business statistics, Daddy.

King Menalaus: I will disagree with you on this point, Princess I-Net, until you support your opinion with data.

Use data from JSMCase1 Excel file [in Module 1 folder], to test three hypotheses hidden in the conversation above. Use regression analysis to investigaete the relationship between age of a student, Internet usage of a student and performance of a student in an assessment of statistical knowledge and skills.

Prince Mean Chaser, Princess Age and Princess I-net have hired you to help them and they have agreed to pay you 1000 dollars if you help honestly settle their dispute with their daddy. They do not want to win for the sake of winning by any means necessary, they want you to discover the honest truth about how reasonable their beliefs are. Which of their beliefs can be supported with 95% confidence? Which of their beliefs can be supported with 99% confidence?

Use the hypothesis testing procedure described in chapters 9 and or 12, as appropriate, to do your analysis. Discuss your findings. Use scatter diagrams, correlation coefficient r and the regression procedure to honestly settle the dispute in the royal family about the relationship between age and performance in business statistics and Internet usage and performance in business statistics.

The chapters for this assignment are on hypothesis testing and single linear regression. I need all backup for the excel solutions and anything you can contribute to help me learn how you came to your analysis.

Attachment:- Case4.xlsx

Verified Expert

The solution contains contains a MS word and MS excel files. The assignment contains solution to 'Hypothesis Testing and linear regression'. It includes a solution to the questions. This is a verified solution and it answers to all the questions mentioned in the requirement.

Reference no: EM131096354

Questions Cloud

How walmarts marginal product labor related to product : How Walmart's marginal product labor related to its marginal product?
Dimensions of national culture : Describe the five value dimensions of national culture as identified by the Hofstede's 1. framework for assessing cultures.
Create the logic for a program that calls a method : discount amount; the customer discount is taken as a percentage of the total price after the salesperson commission has been added to the original price.
Limitations of the attached model schedule : What are the limitations of the attached model schedule? What will not work?
Perform in an assessment of statistical knowledge and skill : They do not want to win for the sake of winning by any means necessary, they want you to discover the honest truth about how reasonable their beliefs are. Which of their beliefs can be supported with 95% confidence? Which of their beliefs can be s..
Make a strong case for decision : We can all agree that each of the four Ps are critical marketing considerations. That said, which one (product, price, promotion, or placement) is the most important and why? Make a strong case for your decision.
Write a program that reads customer records : At some point during record processing, you would add 1 to an array element whose subscript would be represented by _________.
Contracts administrator of the contracts department : You are a mid-level Contracts Administrator of the contracts department. You are responsible for approving invoices being submitted to the Government. You notice on this month's invoice that some charges appear that don't belong to the contract-p..
What starbucks doing right with respect to leading function : Do the overwhelmingly positive results from the 2005 partner survey surprise you? Why or why not? What is Starbucks doing "right" with respect to the leading function? Are they doing anything "wrong?" Explain.

Reviews

Write a Review

Advanced Statistics Questions & Answers

  Define generally accepted accounting principles

Explain what is meant by Generally Accepted Accounting Principles (GAAP). What is the FASB, and what does this organization do?

  Managerial accounting for subsidiaries

The following data summarize the operating performance of your company's wholly owned Canadian subsidiary for 2009 to 2011. The cost of capital for this subsidiary is 10 percent.

  Correlation and regressionuse the subsequent hypothetical

correlation and regressionuse the subsequent hypothetical correlation matrix to answer the first two

  What is the distribution of the time

What is the distribution of the time till the next epoch of N2(t) and what is the probability that the next epoch of N (t) is an epoch in N1(t)?

  Determining cost of equity bu using capm

Booher Book Stores has a beta of 0.8. The yield on a 3-month T-bill is 4% and the yield on a 10-year T-bond is 6%. The market risk premium is 5.5%, and the return on an average stock in the market last year was 15%.

  How would you spend the amount to maximize your return

How would you spend the $2000 to maximize your return and what would be your net return? Explain your answer - Resolve the problem requiring an integer solution.

  What is the multifactor productivity performance

What is the multifactor productivity performance for a course at ABC University and How many automobiles are needed to be produced over the next two years to make the robotic system an attractive investment?

  Capital employed ratio formula

The capital employed ratio formula is used to determine how efficiently capital is being used to generate sales. It subtracts all assets not directly associated with operations, such as investments, and divides the remainder into annual sales.

  What is the probability the client receives an entire stream

what is the expected value and variance of the number of packet retransmissions that will occur before the full stream is received at the client and what is the probability the client receives an entire stream without any dropped packets on the fir..

  Determining dividends and stock valuation

A company pays a dividend today of $4, and this dividend is expected to grow each year by 4%. The discount rate is 10%. What is the market price of the stock?

  One sample t-test-one-sided

The program office budgets $30,000 per program review at the contractor's site. Your concern for "end of year" spending drills is that you have budgeted enough for the reviews

  Imc and promotional strategies of nike

Complete a minimum 800 word paper analyzing today's promotion strategies of the company you have chosen (Nike athletic shoes).

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