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....
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...
Conduct research on an ERP package, such as Microsoft Dynamics GP or Microsoft Dynamics NAV, for...
Conduct research on an ERP package, such as Microsoft Dynamics GP or Microsoft Dynamics NAV, for small to medium-sized (SME) organizations (between $30 million and $1 billion in revenues). Compare that package to the SAP system in terms of available modules, functionality, and so on.
EXCEL ASSIGNMENT You are thinking of advertising Microsoft products on a popular TV music program. You...
EXCEL ASSIGNMENT You are thinking of advertising Microsoft products on a popular TV music program. You will pay 1 price for the first group of ads, but as you buy more ads, the price per ad decreases as shown in the following table... Ad number Price per ad 1-5 $12,000 6-10 $11,000 11-20 $10,000 21 or higher $9,000 For example, if you buy 8 ads, you pay $12,000 for the first 5 ads and $11,000 for each of the next...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT