Please show the excel formulas for the below calculations:

Question 14

Valley	Foothills
109	82
116	161
106	163
157	112
147	222
105	137
173	226
153	200
137	154
110	176

BigDeal Real Estate surveyed prices per square foot in the valley and foothills of Hoke-a-mo, Utah. Based on BD'sDATA,areprices per square foot equal at =0.01?

Question 14 options:

	- None of the answers match my calculation.
	- The critical value is 2.977 since this is a two-tail scenario. The test statistic is 3.207. Since the test statistic > the critical value, the test statistic does lie in the area of rejection. Reject the null hypothesis. The prices per square foot are not equal at alpha = .01
	- The critical value is 2.977 since this is a two-tail scenario. The test statistic is 2.239. Since the test statistic < the critical value, the test statistic does not lie in the area of rejection. Do not reject the null hypothesis. The prices per square foot are equal at alpha = .01
	- The critical value is 2.977 since this is a two-tail scenario. The test statistic is 1.936. Since the test statistic < the critical value, the test statistic does not lie in the area of rejection. Do not reject the null hypothesis. The prices per square foot are equal at alpha = .01
	- The critical value is 2.977 since this is a two-tail scenario. The test statistic is 1.513. Since the test statistic < the critical value, the test statistic does not lie in the area of rejection. Do not reject the null hypothesis. The prices per square foot are equal at alpha = .01
Hint for Question 14
Test H0: Valley mean = foothill mean. Is this paired data (2 measurements dependent on the unit of observation), or data from 2 independent populations? When we do not know if the variances are equal, we assume variances are unequal. Use Data Analysis, t-Test: Two-Sample Assuming Unequal Variances. Take care that the significance level alpha is consistent with the value given in the question and that the Labels check box is only checked if the first row of the Input Range contains variable labels. It is recommended that you include the data labels in the Input Range and check the Labels checkbox. Excel gives critical values for both one tail P(T<=t) and two tail P(T<=t) two-tail tests. Which critical value applies in this problem?

Question 15- ANOVA-1

Ovservation	Portland	Houston	Jacksonville
1	85	71	59
2	75	75	64
3	82	73	62
4	76	74	69
5	71	69	75
6	85	82	67

National Bearings manufactures bearings at plants located in Portland Oregon, Houston Texas, and Jacksonville Florida. To measure employee knowledge of Total Quality Management (TQM), six employees were randomly selected at each plant and tested. The test scores for these employees are given inDATA. Managers want to know if, on average, knowledge of TQM is equal across the 3 plants. Test equality of mean scores at = 0.05.

Question 15 options:

	-The F value of 9 is > the F critical value of 3.682, therefore reject the equality of means. Knowledge of TQM is not equal across the 3 plants.
	- The F value of 1.326 is < the F critical value of 3.682, therefore do not reject equality of means. Knowledge of TQM is equal across the 3 plants.
	- The F value of 3.419 is < the F critical value of 3.682, therefore do not reject equality of means. Knowledge of TQM is equal across the 3 plants.
	- The F value of 6.349 is > the F critical value of 3.682, therefore reject the equality of means. Knowledge of TQM is not equal across the 3 plants.
	- None of the answers match my calculation.
Hint for Question 15 Test H0: Portland = Houston = Jacksonville at = 0.05. What Data Analysis procedure is used to test equality of three population means? Take care to use the Labels checkbox correctly. If the Input Range includes the data labels, check the Labels checkbox. If the Input Range does not include the data labels, do not check the Labels checkbox. It is recommended that you include the data labels in the Input Range and check the Labels checkbox. Verify that the input significance level alpha is correct. Compare the F and F crit values. What is the rule for rejecting H0: Equal means?

Question 16ANOVA - 2

To test whether the mean time to mix a batch of adhesive is the same for machines produced by four manufacturers, TiteBondMax obtainedDATAon the time (minutes) needed to mix the materials. Test whether the machines have equal mean mixing time at =0.05.

Question 16 options:

	- The pvalue 0.0001 is extreme evidence that the machines are not all the same.
	- The data provide weak evidence against H0: Equal means at pvalue 0.072. Equality of means remains plausible.
	- The data provide insignificant evidence against H0: Equal means at pvalue 0.514. The machine are considered equal.
	- The data provide strong evidence against H0: Equal means at pvalue 0.013. The mixing machines are not all equal.
	- None of the answers match my calculation.
	- The data provide extreme evidence against H0: Equal means at pvalue 0.001. The mixing machines are not all equal.
Hide hint for Question 16
Test H0: Equal mixing times at = 0.05. What Data Analysis procedure is used to test equality of three population means? Take care to use the Labels checkbox correctly. If the Input Range includes the data labels, check the Labels checkbox. If the Input Range does not include the data labels, do not check the Labels checkbox. It is recommended that you include the data labels in the Input Range and check the Labels checkbox. Verify that the input significance level alpha is correct. Compare the F and F crit values. What is the rule for rejecting H0: Equal means? We state that the evidence against H0 is Extreme when p value < 0.001 Overwhelming when 0.001 p value < 0.01 Strong when 0.01 p value < 0.05 Weak when 0.05 p value < 0.10 Insignificant when 0.10 p value

Question 17 Pivot Table

Customer #	Eye Condition	Gender
1	Farsighted	Male
2	Bifocals	Male
3	Nearsighted	Male
4	Farsighted	Male
5	Nearsighted	Female
6	Farsighted	Male
7	Farsighted	Male
8	Nearsighted	Female
9	Nearsighted	Male
10	Farsighted	Male
11	Bifocals	Male
12	Farsighted	Female
13	Farsighted	Male
14	Farsighted	Male
15	Farsighted	Male
16	Farsighted	Male
17	Nearsighted	Male
18	Bifocals	Female
19	Farsighted	Male
20	Farsighted	Male
21	Farsighted	Male
22	Bifocals	Male
23	Farsighted	Female
24	Nearsighted	Male
25	Nearsighted	Female
26	Bifocals	Female
27	Nearsighted	Female
28	Farsighted	Female
29	Bifocals	Male
30	Nearsighted	Female
31	Farsighted	Male
32	Bifocals	Female
33	Farsighted	Male
34	Bifocals	Female
35	Bifocals	Female
36	Farsighted	Female
37	Bifocals	Male
38	Farsighted	Male
39	Bifocals	Female
40	Bifocals	Male
41	Farsighted	Male
42	Farsighted	Female
43	Bifocals	Female
44	Farsighted	Female
45	Farsighted	Male
46	Farsighted	Male
47	Bifocals	Female
48	Farsighted	Female
49	Farsighted	Female
50	Bifocals	Male
51	Nearsighted	Male
52	Bifocals	Female
53	Farsighted	Female
54	Farsighted	Female
55	Farsighted	Male
56	Bifocals	Female
57	Farsighted	Female
58	Farsighted	Male
59	Farsighted	Male
60	Nearsighted	Male
61	Farsighted	Female
62	Nearsighted	Male
63	Farsighted	Female
64	Farsighted	Female
65	Bifocals	Female
66	Farsighted	Male
67	Bifocals	Male
68	Farsighted	Female
69	Farsighted	Male
70	Farsighted	Female
71	Bifocals	Female
72	Farsighted	Male
73	Bifocals	Female
74	Farsighted	Female
75	Farsighted	Female
76	Farsighted	Female
77	Farsighted	Female
78	Farsighted	Female
79	Farsighted	Female
80	Farsighted	Female
81	Farsighted	Female
82	Farsighted	Female
83	Farsighted	Female
84	Farsighted	Female

To balance inventory at Otto's Optometry, customer Gender and Eye Condition were collected inDATA.Make a 2x2 pivot table withGender in rows and Eye Condition in columns. The pivot table is

Question 17 options:

There are 3 Steps involved in it Step: 1 Get Instant Access with AI-Powered Solutions See step-by-step solutions with expert insights and AI powered tools for academic success Step: 2 Step: 3 Ace Your Homework with AI Get the answers you need in no time with our AI-driven, step-by-step assistance Get Started Recommended Textbook for Entrepreneurship Authors: Andrew Zacharakis, William D Bygrave 5th Edition 1119563097, 9781119563099 Students also viewed these Mathematics questions Question 1. With 95% confidence, the program director estimated that the proportion of MGMT650 students that are very satisfied is 90% 5%. A. The proportion of very satisfied students cannot be off by more... Answered: 1 week ago Question Valley Foothills 109 82 116 161 106 163 157 112 147 222 105 137 173 226 153 200 137 154 110 176The critical value is 2.977 since this is a two-tail scenario. The test statistic is 3.207. Since the... Answered: 1 week ago Question 1.Choose the answer(s) that is(are) correct. ___Decreasing the confidence level increases the width of a confidence interval. ___Increasing the confidence level increases the width of a confidence... Answered: 1 week ago Question ★★★★★ Raul recently started a real estate company with a unique way of presenting a menu of services, each with a fixed price, rather than usi grown to 21 brokers, and he has plans to expand his model... Answered: 1 week ago Question ★★★★★ Refer to Exercise 2.46 (p. 52), in which we compared state average SAT scores in 2011 and 2014. a. Construct side-by-side box plots of the SAT scores for the two years. b. Compare the variability of... Answered: 1 week ago Question ★★★★★ For the following exercises, draw the graph of a function from the functional values and limits provided. lim f(x) = 0, lim f(x) = 5, lim f(x) = 0, (5) = 4, x x x f(3) does not exist. Answered: 1 week ago Question ★★★★★ Does the person have her/his vita posted? Answered: 1 week ago Question ★★★★★ Krisch Enterprises Inc. produces aeronautical navigation equipment. The stockholders' equity accounts of Krisch Enterprises Inc., with balances on January 1, 2010, are as follows: The following... Answered: 1 week ago Question ★★★★★ Marx Supply uses a sales journal, a purchases journal, a cash receipted journal, a cash disbursements journal, and a general journal. The following transactions occur in the month of April 3... Answered: 1 week ago Question ★★★★★ (Program in scala and please use a main method at the end) Need it asap please! In a package named "execution" create a Scala class named "VoteCounter" with the following: A constructor that takes a... Answered: 1 week ago Question ★★★★★ Your firm-has A/P with credit terms of 1/15, net 30. What is the annualized cost of skipping the discount on day 15 and paying the full invoice amount on day 30? 24.6% 37.2% 18.6% 8.1% Answered: 1 week ago Question ★★★★★ total monthly production costs are 10,000 on a lot of 250 units. you sell each unit for $150. If all 250 units sell each month, how would you calculate your annual profit Answered: 1 week ago Question ★★★★★ One way to determine the trend of a data set is to find ______________________. Question 36 options: a) percentage of non-overlapping data b) the split middle line of progress c) percentage of... Answered: 1 week ago Question ★★★★★ The annual salaries for 5 randomly selected people: Diana: $154,500 Clark: $76,000 Lois: $119,350 Bruce: $2,350,000,000 Barry: $68,000 Which would be the best measure of central tendency for this... Answered: 1 week ago Question ★★★★★ Your clients expect a 10% return on investment for podcast and a 15% ROI for TV ads. How would you calculate the expected profit for a client who invests $5500 on a podcast ad and $10,000 for a TV ad Answered: 1 week ago Question ★★★★★ Tenalpina Tools: Product Line Profitbaility - HBR Case Please provide product costs for hammers, pistons and rock nuts using activity based costing method to combine data on overhead. Is the data... Answered: 1 week ago Question ★★★★★ Determine by direct integration the values of x for the two volumes obtained by passing a vertical cutting plane through the given shape of Fig. 5.21. The cutting plane is parallel to the base of the... Answered: 1 week ago Question ★★★★★ There are n patients needing a kidney transplant. Kidneys arrive according to a Poisson process with rate , and each patient is independently eligible to receive an arriving kidney with probability... Answered: 1 week ago Question ★★★★★ Satellites are launched into space at times distributed according to a Poisson process with rate . Each satellite independently spends a random time (having distribution G) in space before falling to... Answered: 1 week ago Question ★★★★★ Suppose that electrical shocks having random amplitudes occur at times distributed according to a Poisson process {N(t), t 0} with rate . Suppose that the amplitudes of the successive shocks are... Answered: 1 week ago Previous Question Next Question View Answer in SolutionInn App Services Sitemap Fun Definitions Become Tutor Study Help Categories Recent Questions Expert Questions Company Info Security Copyrights Privacy Policy Terms & Conditions SolutionInn Fee Scholarship Get In Touch About Us Contact Us Career Jobs FAQ Campus Ambassador Secure Payment Download Our App © 2024 SolutionInn. All Rights Reserved