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

  Computing intrinsic value of a bond

Twin Oaks Health Center has a bond issue outstanding with a coupon rate of 7 percent and four years remaining until maturity. The par value of the bond is $1,000, and the bond pays interest annually.

  Techniques in business-economics

A sample of the monthly amounts spent for food by families of four receiving food stamps approximates a symmetrical distribution. The sample mean is $150 and the standard deviation is $20.

  Problem 11 there is a formula for sample size n with given

problem 11. there is a formula for sample size n with given margin of error m and condence level c for population

  Residual dividend policy dividend and payout ratio

Fletcher Corp. has a capital budget of $1,000,000, but wants to maintain a target capital structure of 60% debt and 40% equity. The company forecasts this years net income to be $600,000.

  Appropriate statistical analysis

A fashion student was interested in factors that predicted the salaries of catwalk models. She collected data from 231 models.

  Perform simple linear regression

Perform simple linear regression

  Build credibility and expert status in the market place

A growing travel site. Areport written based on the statistics - Build credibility and expert status in the market place.

  Fit a linear regression equation to the data

Does the scatterplot of the price of wine on the rating suggest a linear or nonlinear relationship and fit a linear regression equation to the data, regressing price on the rating. Does this fitted model make substantive sense?

  Determining the number of clusters

What are your personal thoughts about the three different clustering algorithms - Determining the number of clusters

  Find steady-state probability p of state i in embedded chain

Suppose a colleague has calculated the steady-state probabilities {pi} of being in state i for each i ≥ 0. For each i ≥ 0, find the steady-state probability π of state i in the embedded Markov chain.

  Revenue and cost problem

Given the following linear revenue function and quadratic cost function for a business firm, calculate the break - even quantity, total revenue, total cost and profit at break even level of production.

  Develop an anova table for the regression analysis

Develop an ANOVA table for the regression analysis of hours studied as a predictor of the grade earned on the first statistics exam.

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