Question

In: Statistics and Probability

This assignment is designed to illustrate how a software package such as Microsoft Excel supplemented by...

This assignment is designed to illustrate how a software package such as Microsoft Excel supplemented by an add-in such as PHStat can enable one to make decisions about the behavior of a single population parameter. You must provide printouts of all results of the hypothesis tests that you accomplish as you fulfill the requirements of this assignment. You should not only find the required information to make the appropriate decisions, but you also should provide explanations, in the context of the problems, of the meanings of your decisions. Once again, the assignment should be submitted to the course drop box in an organized fashion with at least the first page of this assignment sheet that includes the names of the team members as a cover sheet. This will make it easier to evaluate. Business implications are required for one part of each problem. Reference the relevant portions of chapter 9 both within and at the end of the chapter and the appendices in the back of your text should you need help in using PHStat to complete this work.   

  1. You no longer believe that the population standard deviation in the tuition amounts for this population is a known quantity. You therefore will use the standard deviation in the tuition amounts of a representative sample of universities as an estimate of the unknown population standard deviation. You collect yearly tuition data from a random sample of universities once again. This data is shown in appendix one below. Once again, at each of the 5% and 10% levels of significance, is the mean yearly tuition less than $20,000? Again, in your memo, comment upon the effect of the change in the level of significance on your decision, if necessary. Also, compare, at each level of significance, the results of this portion of the problem to those of the previous part. Account for any difference in your decisions at each level of significance between the two parts of the problem. Make this accounting based not only on a mathematical approach, but rather on a conceptual justification.

    Appendix One: (Tuition Amounts)

               $22,000        $25,412        $18,543           $21,010        $32,500

               $13,476        $18,765        $17,689           $12,378        $21,800

               $19,548        $22,348        $17,659           $18,654        $23,409

               $31,329        $14,489        $15,698           $11,389        $19,901

               $25,671        $18,888        $14,490           $24,468        $15,690

               $13,298        $30,000        $12,390           $21,672        $20,037

               $21,876        $19,090        $21,684           $24,347        $18,000

               $12,769        $17,032        $26,876           $18,923        $15,119

               $15,632        $20,000        $21,769           $15,858        $13,607

               $24,879        $17,540        $14,027           $13,908        $12,690

Solutions

Expert Solution


Related Solutions

HOMEWORK 1 This assignment is designed to illustrate how a software package such as Microsoft Excel...
HOMEWORK 1 This assignment is designed to illustrate how a software package such as Microsoft Excel supplemented by an add-in such as PHStat can enable one to calculate minimum sample sizes necessary in order to construct confidence intervals for both population means and proportions and to construct these types of confidence intervals. You should use PHStat in order to accomplish all parts of this assignment. You should not only find the required information, but you should explain the meanings of...
HOMEWORK 1 This assignment is designed to illustrate how a software package such as Microsoft Excel...
HOMEWORK 1 This assignment is designed to illustrate how a software package such as Microsoft Excel supplemented by an add-in such as PHStat can enable one to calculate minimum sample sizes necessary in order to construct confidence intervals for both population means and proportions and to construct these types of confidence intervals. You should use PHStat in order to accomplish all parts of this assignment. You should not only find the required information, but you should explain the meanings of...
This assignment is designed to illustrate how a spreadsheet program such as Microsoft Excel supplemented by...
This assignment is designed to illustrate how a spreadsheet program such as Microsoft Excel supplemented by PHStat can enable you to easily accomplish hypothesis tests and confidence intervals that compare two population parameters. All work should be accomplished using PHStat. You should provide all the appropriate printouts of the tests you do and the confidence intervals you create along with explanations of the meaning of your answers and business implications for each problem. The assignment should be submitted to the...
Microsoft leases rights to Microsoft Word, Excel, Powerpoint and other software applications to NJCU School of...
Microsoft leases rights to Microsoft Word, Excel, Powerpoint and other software applications to NJCU School of Business, Campus Administration for 14 annual payments of $8,500 at the beginning of each year. The payments will begin five years from today. If the market rate of interest is 8%, what is the present value of the payments? Provide the answer in Excel with formula please
FINANCE ASSIGNMENT **THIS ASSIGNMENT REQUIRES THE USE OF MICROSOFT EXCEL** Refer to information page on the...
FINANCE ASSIGNMENT **THIS ASSIGNMENT REQUIRES THE USE OF MICROSOFT EXCEL** Refer to information page on the use of some finance features in Excel. Understand financial functions @PMT, @PPMT, @IPMT, @PV and @FV. See here. 1. Assume you are employed at $60,000 per year. Consider such deductions as social security, income taxes (federal, state and county) and your payment on health benefits. Do the best you can to come to grips with what is a realistic monthly take home pay. 2....
this is in excel VB8 Program 2: Software Sales A software company sells three packages, Package...
this is in excel VB8 Program 2: Software Sales A software company sells three packages, Package A, Package B, and Package C, which retail for $99, $199, and $299, respectively. Quantity discounts are given according to the following table: Quantity Discount 10 through 19 20% 20 through 49 30% 50 through 99 40% 100 or more 50% Create an application that allows the user to enter the number of units sold for each software package. The application should calculate and...
Excel Assignment 2 Direction: Use Microsoft Excel to answer the following three questions (Excel Instructions are...
Excel Assignment 2 Direction: Use Microsoft Excel to answer the following three questions (Excel Instructions are provided in previous assignment) 1. An Economist was interested in sex differences in the number of books a person reads (see file: Number of Books). Two random samples were taken, one of men and the other, and the number of books read during the last month was recorded. Is there a difference with respect to the number of books read by females and males?...
Instructions: You must use Excel or a similar statistical software package, such as SPSS, for your...
Instructions: You must use Excel or a similar statistical software package, such as SPSS, for your assignment. Tasks: 1.Select thirty stocks (at least 3 different industries) that are listed on the Toronto Stock Exchange. 2.Track each stock’s closing price at the end of the trading day. These closing prices will appear on the Internet. Collect the stock closing price data from January 2017 to December 2019. 4. For each stock, use your data to calculate and interpret: (show calculations) a)the...
Software Sales A software company sells three packages, Package A, Package B, and Package C, which...
Software Sales A software company sells three packages, Package A, Package B, and Package C, which retail for $99, $199, and $299, respectively. Quantity discounts are given according to the following table: Quantity Discount 10 through 19 20% ,20 through 49 30% ,50 through 99 40% ,100 or more 50% . Create a C++ program that allows the user to enter the number of units sold for each software package. The application should calculate and display the order amounts and...
Assignment Steps Resources: Microsoft Excel®, Signature Assignment Databases, Signature Assignment Options, Part 3: Inferential Statistics Scenario:...
Assignment Steps Resources: Microsoft Excel®, Signature Assignment Databases, Signature Assignment Options, Part 3: Inferential Statistics Scenario: Upon successful completion of the MBA program, say you work in the analytics department for a consulting company. Your assignment is to analyze one of the following databases: Manufacturing Hospital Consumer Food Financial Select one of the databases based on the information in the Signature Assignment Options. Provide a 1,600-word detailed, statistical report including the following: Explain the context of the case Provide a...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT