Saeko owns a yarn shop and want to expands her color selection. Before she expands her colors, she wants to find out if her customers prefer one brand over the other brand. Specifically, she is interested in three different types of bison yarn. As an experiment, she randomly selected 15 different days and recorded the sales of each brand. At a .05 significance level can she conclude that there are differences in preference between the brands?

1. What is the null hypothesis?

2. What is the alternate hypothesis?

3. What is the level of significance?

Use Tools-Data Analysis-Anova Single Factor Anova: Single Factor to find the F statistic;

4. from the ANOVA output; What is the F value?

5. What is the F critical value?

6. What is your decision?

Use the "Pivot Table Data" tab to crate a pivot table that shows Seako the number of yards and meters that were sold in the various yarn types during the busiest weekend of her shop last year.

PLEASE SHOW HOW TO DO ALL EXCEL FUNCTIONS. THANK YOU!

12: A random sample of 50 drive-thru customers at Burger World (a subsidy of Malco, Inc.) was taken to determine the average transaction time after the order was placed during the evening rush (4:00 PM to 6:00 PM).   The edited Data Analysis output is shown below. Answer the following five questions. (3.5 pts.)

1. Identify the degrees of freedom and the critical value of t used in the calculation of the 95% confidence interval.

2. Calculate the lower confidence limit (LCL) and the upper confidence limit (UCL). (Round the LCL and UCL to two decimal places, (i.e., 12.13, 45.67.)

3. Interpret the confidence interval: I am _____ confident that the _________ of transaction time is between the lower confidence limit (LCL) and the upper confidence limit (UCL).

4. If the confidence level is changed to 99 percent, does the width of the confidence interval increase or decrease?

5. Would it be reasonable or plausible to conclude that the population mean is four minutes? Explain your reasoning.

6. What is the standard error of the mean? Show the SE to three decimal places, (i.e., .123).

7. What sample size is needed to reduce the standard error by half?

A researcher randomly assigns 33 subjects to one of three groups. Group 1 receives technical dietary information interactively from an on-line website. Group 2 receives the same information from a nurse practitioner, while Group 3 receives the information from a video made by the same nurse practitioner.

The researcher looked at three different ratings of the presentation: difficulty, usefulness, and importance to determine if there is a difference in the modes of presentation. In particular, the researcher is interested in whether the interactive website is superior because that is the most cost-effective way of delivering the information.

1. Run the appropriate analysis of the data and interpret the results.
2. How could this study have been done differently? Why would this approach be better or why would it not be?

Exercise 2

The following data represent the mutual fund prices reported at the end of the week for selected 42 nationally sold funds.

10        17        15        18        22        19        10        17        18        25        11        13        35        28

27        29        39        31        35        33        22        24        28        35        45        50        47        38

41        31        21        11        49        38        35        25        33        42        27        15        28        34

1. Organize the data.
2. Present the data.

Exercise 3

Twenty MBA students have got the following marks out of 100 in three courses in the first semester.

1. Organize the above data in meaningful form.
2. Present the data.
3. Analyze and compare performance of students in three courses.

Exercise 4

A random sample of 8 MBA students from two sections of same batch are selected from of a B-School. The marks scored by these students are given below;

On the basis of sample statistic find out (show working),

1. Which section is more consistent?                                                           
2. Which section’s overall performance is better and why?

Exercise 2-2
The following A. B. Murphy Company data show purchase and sales transactions for the month of April. A. B. Murphy uses a perpetual inventory system.

Compute the following:
1.   Cost of (1) goods available for sale and (2) number of units for sale.

2.   Number of units in ending inventory.

1.   Cost assigned to ending inventory, using any three of the following four methods. Compute costs using all four methods for distinguished performance. Round per unit costs to three decimal places and inventory balances to the nearest dollar.
a.   FIFO.
b.   LIFO.
c.   Weighted average.
d.   Specific identification (see note below).

FIFO Perpetual

LIFO Perpetual

Weighted Average Perpetual

Specific Identification
Note:   The April 12 sale comprised 55 units from beginning inventory and 180 units from the April 8 purchase. The April 27 sale comprised 30 units from the April 19 purchase and 65 units from the April 23 purchase.

1.   Gross profit, using FIFO, LIFO, weighted average, and specific identification.

Exercise 2-2
The following A. B. Murphy Company data show purchase and sales transactions for the month of April. A. B. Murphy uses a perpetual inventory system.

Compute the following:
1.   Cost of (1) goods available for sale and (2) number of units for sale.

2.   Number of units in ending inventory.

1.   Cost assigned to ending inventory, using any three of the following four methods. Compute costs using all four methods for distinguished performance. Round per unit costs to three decimal places and inventory balances to the nearest dollar.
a.   FIFO.
b.   LIFO.
c.   Weighted average.
d.   Specific identification (see note below).

FIFO Perpetual

LIFO Perpetual

Weighted Average Perpetual

Specific Identification
Note:   The April 12 sale comprised 55 units from beginning inventory and 180 units from the April 8 purchase. The April 27 sale comprised 30 units from the April 19 purchase and 65 units from the April 23 purchase.

1.   Gross profit, using FIFO, LIFO, weighted average, and specific identification.

A researcher randomly assigns 33 subjects to one of three groups. Group 1 receives technical dietary information interactively from an on-line website. Group 2 receives the same information from a nurse practitioner, while Group 3 receives the information from a video tape made by the same nurse practitioner.

The researcher looked at three different ratings of the presentation; difficulty, usefulness, and importance to determine if there is a difference in the modes of presentation. In particular, the researcher is interested in whether the interactive website is superior because that is the most cost-effective way of delivering the information.

1. Run the appropriate analysis of the data and interpret the results.

2. How could this study have been done differently? Why or why not would this approach be better?

1 7.94 111 2 54 2 8.292 119 2 63 3 4.643 96 2 36 4 7.47 115 2 50 5 8.882 117 1 46 6 7.585 101 2 67 7 7.65 129 2 47 8 2.412 82 2 43 9 6 108 1 54 10 8.833 112 2 67 11 7.47 120 1 41 12 5.528 93 1 35 13 7.167 110 2 50 14 7.571 100 1 80 15 4.7 101 1 38 16 8.167 114 1 45 17 7.822 113 1 54 18 7.598 113 1 61 19 4 108 2 42 20 6.231 107 1 72 21 7.643 120 2 54 22 1.76 78 2 58 24 6.419 112 1 53 26 9.648 123 2 69 27 10.7 119 1 56 28 10.58 124 2 60 29 9.429 114 2 64 30 8 120 2 40 31 9.585 120 2 63 32 9.571 106 1 51 33 8.998 124 1 46 34 8.333 102 1 45 35 8.175 114 2 63 36 8 119 2 44 37 9.333 108 1 65 38 9.5 108 2 67 39 9.167 118 2 66 40 10.14 106 1 72 41 9.999 114 1 57 43 10.76 132 2 51 44 9.763 114 2 67 45 9.41 117 2 63 46 9.167 138 2 78 47 9.348 127 2 60 48 8.167 102 2 64 50 3.647 92 2 47 51 3.408 102 1 36 52 3.936 90 2 36 53 7.167 101 2 51 54 7.647 117 2 72 55 .53 90 2 39 56 6.173 87 2 54 57 7.295 94 2 57 58 7.295 122 1 63 59 8.938 101 1 55 60 7.882 118 1 53 61 8.353 120 2 64 62 5.062 108 2 49 63 8.175 104 2 56 64 8.235 109 2 75 65 7.588 122 2 52 68 7.647 100 2 82 69 5.237 101 1 49 71 7.825 117 2 73 72 7.333 91 1 59 74 9.167 130 2 60 76 7.996 103 2 54 77 8.714 95 1 41 78 7.833 106 1 80 79 4.885 89 2 49 80 7.998 118 1 48 83 3.82 74 2 68 84 5.936 91 1 49 85 9 105 1 59 86 9.5 125 1 54 87 6.057 119 2 46 88 6.057 100 1 43 89 6.938 107 2 82

contains information on 78 seventh-grade students. We want to know how well each of IQ score and self-concept score predicts GPA using least-squares regression. We also want to know which of these explanatory variables predicts GPA better. Give numerical measures that answer these questions. (Round your answers to three decimal places.)

1 7.94 111 2 54 2 8.292 119 2 63 3 4.643 96 2 36 4 7.47 115 2 50 5 8.882 117 1 46 6 7.585 101 2 67 7 7.65 129 2 47 8 2.412 82 2 43 9 6 108 1 54 10 8.833 112 2 67 11 7.47 120 1 41 12 5.528 93 1 35 13 7.167 110 2 50 14 7.571 100 1 80 15 4.7 101 1 38 16 8.167 114 1 45 17 7.822 113 1 54 18 7.598 113 1 61 19 4 108 2 42 20 6.231 107 1 72 21 7.643 120 2 54 22 1.76 78 2 58 24 6.419 112 1 53 26 9.648 123 2 69 27 10.7 119 1 56 28 10.58 124 2 60 29 9.429 114 2 64 30 8 120 2 40 31 9.585 120 2 63 32 9.571 106 1 51 33 8.998 124 1 46 34 8.333 102 1 45 35 8.175 114 2 63 36 8 119 2 44 37 9.333 108 1 65 38 9.5 108 2 67 39 9.167 118 2 66 40 10.14 106 1 72 41 9.999 114 1 57 43 10.76 132 2 51 44 9.763 114 2 67 45 9.41 117 2 63 46 9.167 138 2 78 47 9.348 127 2 60 48 8.167 102 2 64 50 3.647 92 2 47 51 3.408 102 1 36 52 3.936 90 2 36 53 7.167 101 2 51 54 7.647 117 2 72 55 .53 90 2 39 56 6.173 87 2 54 57 7.295 94 2 57 58 7.295 122 1 63 59 8.938 101 1 55 60 7.882 118 1 53 61 8.353 120 2 64 62 5.062 108 2 49 63 8.175 104 2 56 64 8.235 109 2 75 65 7.588 122 2 52 68 7.647 100 2 82 69 5.237 101 1 49 71 7.825 117 2 73 72 7.333 91 1 59 74 9.167 130 2 60 76 7.996 103 2 54 77 8.714 95 1 41 78 7.833 106 1 80 79 4.885 89 2 49 80 7.998 118 1 48 83 3.82 74 2 68 84 5.936 91 1 49 85 9 105 1 59 86 9.5 125 1 54 87 6.057 119 2 46 88 6.057 100 1 43 89 6.938 107 2 82

contains information on 78 seventh-grade students. We want to know how well each of IQ score and self-concept score predicts GPA using least-squares regression. We also want to know which of these explanatory variables predicts GPA better. Give numerical measures that answer these questions. (Round your answers to three decimal places.)

posting for sec times any incomplete work will be reported answer all 2 parts investment 1 to 7 and finacial statment and valution 1 to 6

You are working for The Wellington Company on temporary assignment while one of the accountants is on family leave. You have been asked to review the company’s investment journal entries and provide necessary information to the accountant preparing the financial statements.

PAGE 8

JOURNAL

ACCOUNTING EQUATION

Investments

Review the journal entries on The Wellington Company panel then answer the following questions.

7. Which of the following investments are likely to be available-for-sale securities? Check all that apply.

Harding Construction stock

Mays and Co. stock

Cannot be determined

Red Rock Co. stock

Sunset Village bonds

Minions Corp. stock

Financial Statements and Valuation

The accountant preparing the financial statements has asked you to provide the fair value as of the end of the year for the investments. Present the information as it would be shown on the financial statements. Last year, The Wellington Company reported costs of $68,000 in trading investments and $82,000 in available-for-sale investments. Refer to the journal entries shown on The Wellington Company panel. Assume that all investments sold during this year were trading investments and that purchases during the year were new investments.

1. Select the correct label for each line and fill in the amount. In classifying the investments, choose a categorization which seems most likely, given the pattern of transactions in the journal entries. Enter all amounts as positive numbers. If an amount box does not require an entry, leave it blank.

6. Which of the following items does not affect net income? Check all that apply.

only unrealized gains or losses for all investments

realized loss on available-for-sale securities

realized gain on trading securities

none of these answers is correct

both gains and losses of any sort for all investments

unrealized loss on trading securities

unrealized gain on available-for-sale securities