Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Your rm is a major retailer of outdoor recreation equipment and accessories with numerous locations spread throughout the southeastern United States. A recent idea is

image text in transcribed

Your rm is a major retailer of outdoor recreation equipment and accessories with numerous locations spread throughout the southeastern United States. A recent idea is to have promotional signage throughout your stores with QR codes that customers could scan that would provide additional information about what products the customer might be interested in. The belief is that when a customer is exposed to additional information about the products available, they will spend more on those products. Your team has developed the QR app, and have produced and placed signage throughout all of your stores. The app provides, when used, information on products within the section of your store that the customer uses the QR scanner. For example, one section of the store is devoted to items for travel (clothing, transportation accessories, etc.) are located in section 1. Another section, section 2, is devoted to high-adventure products that are associated with things like mountaineering, mountain biking, whitewater paddling, etc. Section 3 has products that would appeal to young couples, such as outdoor furniture, dual sleeping bags and hammocks, etc. Finally, section 4 has equipment for outdoor sports such as golf, pickleball, and road cycling. You will be using the same data in the excel spreadsheet assignment and project data.xlsx that you used for the previous assignment.

sectionscanexpendituresagemarriedsex
2yes196924yesM
2no140720noF
1no892360yesM
4yes534946yesM
2no124719noF
3no365032noF
4yes535142yesF
2no137628yesF
3no401744yesM
3yes560046noM
2yes195125yesM
2yes197123yesF
3yes451341yesF
3yes224528yesF
2yes150531noM
2yes206423noF
1no863058noF
3yes468945yesM
1yes908666yesM
2no100720noF
2yes165621noM
4no632747noF
1no878562noM
2yes208923noM
2yes193425noM
4no706049yesM
2no91319noF
4no635744yesF
3yes227125yesM
1no835657yesM
3no362044noF
4no831553noM
1no853058yesF
4yes768142yesM
1no846656yesF
4no668424yesF
3yes512540yesM
4yes759753yesM
4no830457yesM
4no657545yesM
3no384424noF
2no60119noF
4yes771853yesM
3no374633yesM
4no819744yesF
1yes970874yesM
4yes536944yesM
1no897262yesF
4no814753yesM
3no427940yesM
4yes737750yesM
4no661946yesF
1yes906970yesM
1yes989374yesM
3no370838noM
3yes496044noM
3no398935noF
1no807850yesF
3no372634noF
3no378233yesF
4yes758855noM
1no857754yesF
3no400522noF
2no151121noF
2yes142623noF
3yes918666yesF
3no434139noM
4no612835yesM
1no876259yesF
4no673244yesF
2no107720noF
1yes941069yesM
2yes172423yesM
3yes437242noM
2yes150623noF
4no679946yesF
3no443045yesF
2yes172923noM
4no678648noM
3no393633noF
4no614648yesM
2no90019noF
2yes200424noM
2no105519noF
4no826853yesM
1yes1022068yesF
4yes794053yesM
3yes447443noF
3yes230930noF
4yes709450yesM
4no640145noF
2yes175323yesM
4yes752950yesM
4no789052yesM
4no679245yesF
3no373233noM
4no823355yesF
4no635148yesM
2no136719noM
4no643446yesF
3yes451140yesF
3no428438yesF
2yes158121noF
3no405337yesF
4no589444yesF
1no875557yesM
3yes480245noF
3yes478644yesF
2yes193128noM
1no883260yesM
2yes207725noM
2yes210723noF
4no590245yesF
3no395034noF
1no896961yesF
3no418337yesM
3no398336noM
2yes155520noF
2no76918noF
3no366031noM
4no601932yesF
4yes743124yesF
2yes242129noF
4yes747154yesM
3no411443noM
1yes940266yesM
1yes906169yesM
3yes473841noM
2yes204225noM
1no835647yesM
4no671046noM
1no885862yesM
1yes929367yesM
1yes930269yesM
4no638744yesF
2yes189924noM
2yes236622noM
3no348431noM
2yes173825noM
2no122020noF
4no681646yesM
4no605344noM
3yes467743noF
3yes490032yesM
2no62825yesF
2no91318noF
1no850554yesM
3yes514843noM
4yes798750yesM
4yes732648yesM
1yes1016673yesM
4yes767855noM
4no657452yesM
4no664044noF
1yes945655yesM
4no660344yesF
1no861658yesF
4no644447noF
4no685546noM
4no679044yesM
4yes732247yesM
1no865054noF
4yes723849yesM
4no645148noF
1no876460yesF
3no418739noF
3yes484144noM
2no65924yesF
3no418424yesM
3yes228626noM
4no646445yesF
4no615444yesF
1yes913247yesF
4yes795634noM
3yes496045yesM
1no872357yesM
4no639344noF
2no78719noF
2yes195328noF
4no599343yesF
4no828855yesM
1yes881159yesM
1no835637yesM
4no654624yesM
3yes245330noF
1no808651yesF
1yes993172yesM
4no681924yesF
4no638347yesF
2yes189925noF
2no115920noF
2no94225noF
1no884961yesF
2no144225noM
3yes504324noM
1no859456yesF
4no630144yesF
3yes210832noF
4no677047yesF
4no711646yesF
4no661045yesM
4yes743454yesM
3yes481840noF
4no819754yesF
2yes201632noM
4yes722247yesM
1no870955yesM
4no690649noM
3yes224427yesM
3yes433838noM
4no670952yesM
3yes502243yesM
3yes526544noF
3no368332noM
1no897565yesF
2no147021noF
3yes924765yesM
1no853057noF
4yes731044yesM
2yes205724noM
1no841556noF
3yes518344noF
4yes734149yesM
4yes766934yesF
1yes979044yesM
4no684252yesM
3yes211031yesM
3yes485340yesM
3no364031noM
1no843758yesM
4yes767454noF
1yes954865yesM
2yes152521noF
2no103419noM
3no405934yesF
2yes209825yesM
1no914070yesF
3yes235131noF
2yes246431noM
1yes1002775yesM
2yes189031noM
3yes213532noF
4yes766953yesF
4yes738447noM
1no886665noM
1no916465yesF
4no811652yesM
2yes232126noM
1yes975472yesM
3yes510944noM
3yes478532yesF
4yes744251yesM
4no658244noF
1yes946667yesM
3no393034noM
2yes180323noM
1no806655yesM
4no640246yesM
1no858154yesM
2yes168923noM
1yes970275yesM
4no671747noF
3yes474648noF
3no395733yesF
3no424039noM
3yes435240yesM
1no859255yesM
4no631345yesF
2no88023noF
1yes949570yesM
4no695347yesF
2no118125yesF
3no443328yesF
1no818754noM
3no403336noF
3yes482041yesM
4no648848yesF
3yes467732noF
3yes457545noF
2no105432noM
4no641432yesM
3no371832noF
2yes194224noF
1no894160yesM
1yes931445yesM
4no670344yesF
3yes230228noM
3yes221528yesM
4no597342noM
3no450645yesF
3yes497240yesM
4yes786751yesF
4yes763150yesM
1no850247yesF
4no662947yesM
1no838934yesF
2yes172325yesM
3yes506742yesM
4yes535543yesM
4yes729142yesM
2yes194023noM
1no840655yesF
3yes507332noM
3yes555845noF
2no129820noM
2yes172525noM
3no381234yesF
2no142620noM
4no625846noF
4yes784950yesF
4no670048yesM
2no117528yesF
2no110419noM
4no638146yesM
3yes487941noM
1no854956yesF
4no693046yesM
3no388133noF
4yes741149noM
1no884160yesF
3yes465940yesF
1yes984473yesM
2no60618noF
2no92418noM
4no602846yesF
3yes924370yesF
2yes200023noF
2yes149120noM
2no120419noF
4no651945noF
4yes722948yesM
3no420840noF
4yes781655yesM
3no417636noM
2yes206628yesM
1no852457yesF
2yes172424noM
1no866755noF
3yes221925yesF
3yes490940noM
2no55518noM
3yes450344noF
4no642945yesF
3no383334noF
4yes762855yesM
4no640347yesF
4no656248yesF
4no653446noF
3no422938noF
4yes776554yesM
1no879165yesF
1no855158noF
1yes956466yesM
1yes961970yesF
1no856856yesF
4yes533344yesM
4yes534345yesF
1no877260noM
4no684350yesM
4no648147yesM
4yes537644yesF
1no862856yesM
4yes766637yesM
2no65819noF
3yes221425noM
1no880147yesF
4yes746337yesM
3no411737yesM
2no87225yesF
4no606424noF
2yes191323noM
2no99623noF
4no675646yesM
4yes759651yesM
2no104419noF
3no403235noM
1yes965074yesM
4yes724150noF
4yes540942yesF
4no617745noM
2yes197623yesM
3yes211224yesM
1no867547noM
2yes134620noF
4yes731546yesM
3yes921667yesF
3no455443noM
4yes569342yesM
3no410835noF
4yes754451yesM
3yes520945noF
2yes208124noM
4no697648yesM
4yes737746yesM
2yes146820noF
2yes209724yesF
3yes466324yesF
2yes148921noM
1no847358yesF
4no832655noM
1no876245yesF
2yes199931yesM
2yes169724yesM
4no689948noF
4yes800651yesM
4yes553944yesF
2no99220noF
2yes183925yesM
4no669547yesF
1yes963072yesM
1no868657yesM
3yes439343noM
3yes513041noM
4yes754652noM
3no403036noM
1no874556yesM
1yes960469yesM
1no801652yesM
4no626647yesM
1no853958noM
1yes970555yesM
3yes221524noM
3yes211425yesM
1no903466yesM
2yes157720noF
1no806154yesF
4no831954noM
1no854054noF
3yes471340yesM
1yes934144yesM
2yes179925noM
2yes141620noF
1no835755yesM
1yes885945yesM
3yes230432noF
1no874355yesM
4no681948yesM
3no409036noF
3yes214524noF
3yes482743noM
3no380233yesF
3no384333noF
3yes494342yesM
1yes957145noM
4yes759652yesM
1no861357yesF
4no645744yesM
1no854454yesF
3no373234yesM
1no856847yesF
2yes207923noF
4no828754yesM
3no415836noF
2no97619noF
2yes148720noF
1yes926366yesM
1no877361noM
4no636345yesM
3no412335noF
2no76718noF
2yes146021noF
4no796355noM
4yes745452yesF
3no445641yesM
1no854555yesM
2yes156325yesF
3no397034yesF
1no853837noM
4yes538735yesF
2yes163621noM
3yes506641yesM
2yes210724noM
2no141421noF
3yes430140noF
2yes179624noM
1yes1018774yesF
4no647446yesM
3no401438yesF
1no892960yesM
2no131619noF
4yes738648noM
2no116119noF
4no627648yesM
3no379234yesF
1yes944370yesM
4no650544yesF
2no116120noF
4yes729552yesM
4no594046noF
3yes511248yesM
1no862555yesM
3yes225229yesM
4no663048yesM
2yes230925noF
1no903647yesM
1yes982575yesF
2yes208725noF
3no391034noM
3yes274432noF
4no692150yesM
1no856357noM
3no436844yesM
3yes490045noF
1yes912567yesF
4no824634yesM
3no411834yesF
4yes689447noM
2yes189723yesF
3yes488542noM
1no855047yesM
1yes908465yesM
4yes756654noM
4no641252yesM
3no435140yesM
4yes819655noM
1yes946366yesF
1yes883560yesM
2no43023noM
2no88518noM
3no408935noF
3yes493741yesF
4yes543943yesF
1no839654yesF
4yes731450yesM
1no844857yesF
2yes202824yesF
1no833356noM
4no631632noF
3no358431noM
4no664545noF
3yes923269yesF
3no352422noF
1no843457noM
2yes143321noF
3yes453242noM
4yes744042yesF
4yes771752yesM
4yes681047yesF
2no58523noF
3yes484544yesM
3no375634yesF
2yes173325yesM
1no851756yesF
4no657846yesF
4no674245yesF
4yes572043yesF
2yes199424yesF
3yes467242noF
3yes500442noM
1yes940667yesM
4no804137yesF
3yes429143noF
3yes531643yesM
1yes996555yesM
3yes500041noM
4no825057yesM
3yes223526yesF
3no415822noF
3no397535noM
1no850634yesM
3yes489035yesF
4yes602645yesM
3yes482242yesM
3yes527842yesM
4yes762054yesF
3yes503944yesM
4no672948yesF
2no151220noF
3no376922noF
3yes460645yesF
1yes948969yesM
4yes727146noM
1no871856yesM
4yes759550yesM
3no401735noM
3yes513942noM
3yes494743noF
3yes506340noM
1yes899865yesM
3no442144noF
2yes207124noF
2yes163420noF
3yes226830noF
2yes163720noM
4yes771051yesM
2no104320noF
4yes747755yesM
1no837056yesM
4no829456yesM
2yes165731noM
2yes205223noF
4no681348yesF
3no445645noM
4no614047yesF
1no891059noM
4no658848noF
4yes755653noM
2yes229827noM
2no137120noF
2yes201225noF
image text in transcribed
4. The primary hypothesis oftbis problem is that \"when a customer is ex-posed to additional information about e products available, they will spend. more on those products\". Is this hypothesis directly testable? What hypothesis (or hypotheses} is {are}? 5. The point of promoting the use of QR codes is to try to increase mail,- dint-FEE.- Conduct a ttest of di'erences in mean expenditures by QR scannsage . {a} What are the mean expenditures by scan? lab} What is the null hypothesis? {C} What is the test statistic? {:1} Would you reject e mil] hypoesis at a = 1105? {c} Ifthis were all the information you had available, what would you conclude about QR scan usage? ti. Now conduct e following hypoesis tests. Note at in these tests you are making inferences about the statistical dependence between a numeric variable and a categorical variable. Use a = 0.05. {a} Is ere a statistically signicant difference in the mean expenditures between male and female customers? {b} Is ere a statistically signicant difference in the mean expenditures between married and single customers? {C} Is there a statistically signicant difference in e mean age between customers who use the QR. scanner and ose who do not? {:1} Is there a statistically signicant difference in e mean age betweennrale and female customers? {13] Is there a statistically signicant difference in e mean age betweennrarried and slngle customers? In reporting e results ofthese hypothesis tests DO NUT cut and pasteexcel output. Write out your results in a summary narrative. ?. Now compare the categorical variables with x1 tests of independence (us-i354: = 0.05} between: {a} scan and section Are customers in some sections more likely to scan? {b} scan and married. Are single customers more likely to scan? {C} scan and sex. Are female customers more likely to scan? {:1} section and sex. Are male customers more likely to shop in specific sections? 'Note that this is essentially a test of independence between expenditures and QR. scan In reporting the results of these hypothesis tests DU NOT cut and paste excel output. Write out your results in a summary narrative. 3. There is a lot going on in is data set. Consider only one subset of the variables: expenditures, scan, and section. In question [:5], you found atcustomers who use the QR. scanner spend significantly less an custom erswho do not use e scanner, which seems to indicate at using the QR scanner does no: work in increasing spending. But now consider your ndings in question 3, where you found that e average expenditures were higher for those who scanned in our}? section. Finally, consider your answer in question Ta}, where you found that the probability ofusing thesc anner is different by section. 1|What might the interaction oftbese three variables (expenditures, scan, and section) say about the effectiveness (or-ine'ectiveness} ofusing the QR scanner in increasing expenditures? This is only one of many subsets that you could consider wi this data. You might think about oer interactions in anticipation ofyour final project

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

International Business Competing in the Global Marketplace

Authors: Charles W. L. Hill

11th edition

1259578119, 978-1259578113

More Books

Students also viewed these Economics questions

Question

8. How can an interpreter influence the message?

Answered: 1 week ago

Question

Subjective norms, i.e. the norms of the target group

Answered: 1 week ago