Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Need help with Excel (do it on excel and share plz) 1) Two-Sample t-Test A B C D E F G H Daily Sales of

Need help with Excel (do it on excel and share plz)

1) Two-Sample t-Test

image text in transcribedimage text in transcribed
A B C D E F G H Daily Sales of Store 1 ($) Daily Sales of Store 2 ($) O O N 5849 4697 Please provide your answers here in this textbox: 6849 4681 6849 4693 a) Is the test one-tailed or two-tailed? ANSWER -> JOUAW 6849 4732 b) Do you reject or fail to reject the null hypothesis? ANSWER -> 4681 4714 (c) What is the reason for the answer you provided in part (b)? O 4731 4705 p-value method ANSWER -> 4685 4703 4663 4673 critical value method ANSWER-> 4661 4728 11 4710 1739 O O 12 4621 1751 The result of your test should be placed here! 13 4655 1704 14 4704 4640 15 4746 4719 16 4673 4643 17 4758 4667 18 4691 4701 19 4673 4722 20 1753 1742 21 4728 4763 22 4636 4744 23 4694 4659 24 4721 4738 25 4669 4681 26 4632 4690 27 4769 4669 28 4752 4741 29 4670 4710 30 4684 4733 31 4767 4691 32 4661 4700 33 4672 4710 34 4693 4719 35 4716 4694 36 4676 4702 37 4738 4716 38A B C D Weekly Sales of Store 1 ($) E F Weekly Sales of Store 2 ($) G Weekly Sales of Store 3 ($) $14,915 $14,933 $14,970 $14,965 Please provide your answers here in this textbox: $14,897 AWN $14,963 $15,008 $14,996 $14,974 $14,963 a) Do you reject or fail to reject the null hypothesis? ANSWER -> $15,023 $15,084 $14,985 $15,131 b) What is the reason for the answer you provided in part (a)? ANSWER: -> $14,919 $14,963 60 00 VO) $15,057 $14,827 $14,862 $15,003 $14,906 $14,855 $14,979 $15,179 10 $14,949 $14,966 11 $14,946 $14,952 $14,980 $15,158 12 $15,067 $14,953 13 $14,967 $15,082 The result of your test should be placed here! $15,035 14 $15,019 $15,149 $15,034 $14,905 15 $14,956 $14,951 $14,912 16 $14,941 $14,915 17 $15,133 $15,073 $15,002 $14,984 18 $14,99 $15,251 19 $14,940 $15,015 $15,089 20 $15,006 $15,018 $14,991 21 $15,132 $15,022 $15,096 22 $15,033 $15,127 $14,946 23 $15,002 $15,100 $14,874 $14,923 24 $14,86 $15,146 $14,846 25 $15,013 $15,042 26 $14,800 $15,067 $14,990 27 $15,141 $14,944 $15,046 28 $15,057 $14,860 $15,098 29 $15,120 $15,013 $15,018 30 $14,902 $15,106 $14,952 $14,878 31 $15,005 $15,189 32 $15,179 $14,870 $15,026 33 $15,057 $14,935 $15,030 34 $15,120 $15,088 $14,937 $15,015 35 $14,998 $15,000 $14,874 36 $15,024 $14,840 $15,124 37 $15,104 $15.061 $14.968 38

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

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

Linear Algebra A Modern Introduction

Authors: David Poole

3rd edition

9781133169574 , 978-0538735452

Students also viewed these Mathematics questions