Insert LO Calibri v 11 A A ap Wrap Text General Ex AY O Delete ~ Paste Cell Sort & Find & Analyze BIUY A Merge & Center ~ $ ~ % 9 00 -20 Conditional Format as Formatting " Table " Styles |Format Filter * Select ~ Data Clipboard IS Font Alignment Number Styles Cells Editing Analysis POSSIBLE DATA LOSS Some features might be lost if you save this workbook in the comma-delimited (.csv) format. To preserve these features, save it in an Excel file format. Don't show again X i Save As... A A1 X fx Satis 1 S T U V W X Y Z AA AB AC AD AE AF AG AH Al AJ AK 19 2 2 2.166667 4 5 20 4 4 3.916667 4.75 5 4 4.666667 ONDWN HUADUA 22 5.125 N 2 2.166667 23 6 AOUIHUAOUH 5 5.666667 5.875 in VUDAWHUAWA A W 4.25 75 HN NN ANNUANW WWH in 26 4 4.583333 27 4 4 AHWANNNUNNAWNUNNN 00 A UT W UT W UT O W W W W H UT N A W N 3.25 75 DO NO DONATO NO HV NO AN V W D O A A N U W N W W H UN WWA A W W U UT W UT D UT D N A H U NADW 4 4.416667 4 4 4.916667 4 2 3.583333 2 3.833333 UNAOUIWUTVIA 5 5 4.666667 AVAUIDO 33 5 UI 34 5 4.333333 5.75 WUHN 35 4 W 3.5 4.125 3.416667 5.875 4 U 36 5 3 Correlation and Regression Data (+ 4 Ready Accessibility: UnavailableFormatting Table v Styles v Format Filter ~ Select v Data board Font IN Alignment Number Styles Cells Editing Analysis POSSIBLE DATA LOSS Some features might be lost if you save this workbook in the comma-delimited (.csv) format. To preserve these features, save it in an Excel file format. Don't show again Save As... X V fx Satis 1 AB AC AD AE AF AG AH Al AJ AK AL AM AN AO AP AQ AR AS AT 5 2 1.2 4.75 A 3 .2 AUTO WNAN ANWH 4 WN D W W N W H 2.1 NW WW H D N 5.125 NUN 3.6 5.875 N N A A NUNWH 2.5 1.5 VUDOWHUAWA 4.3 75 NA .5 D UT UT UT UT UT O UT UT UT A WUT A D UT UT 75 NAH W H N N N W N H W H NUNWA N W H W O H N N W O H W H W W N W H 5.25 NUN NAHAMANNWNHAHA NWWWNWHWNHAP WUHNNNNANNUL is 4.75 JAHWANNNA 5.75 3.1 HWAN 5.25 3.3 5.75 1.5 JWHAT 4.125 3.8 6 5.875 Correlation and Regression Data + 4wod Insert = ce Wrap Text General L Delete Paste BIUVY 3 E Merge & Center $ ~ % 9 00 -20 Conditional Format as Cell Sort & Find & Analyze Formatting Table ~ Styles Format Filter ~ Select Data Clipboard Font Alignment IS Number Styles Cells Editing Analysis POSSIBLE DATA LOSS Some features might be lost if you save this workbook in the comma-delimited (.csv) format. To preserve these features, save it in an Excel file format. Don't show again Save As... X A1 X V fx Satis 1 R S A A B C D E F G H J K L M N O P Q 36 4 4.666667 W 5.5 37 6 4.916667 38 4 5.583333 39 6 6.333333 ANAUWVUAUDI 2 3.333333 5 5.416667 5 5.666667 J UI UI A N W W A UT UT O UT UT UT D A W WD NUNWUOWNOOVANUAOUT 1 1.916667 J AUIN AU OWN NUUANOUTMAL N A WUV OWN N N O WOODMUTI JU ON A WU NOW UU NOVOUP 4 6.166667 1 3.333333 W 5.25 JAWANWOWOUT 3 4.333333 DWO ADDI WAWWAD 1 2.333333 50 5 5.166667 51 5 3.333333 A 52 4 Correlation and Regression Data (+) + 100% 1:02 PM Ready 7? Accessibility: Unavailable 91 OF 9/22/2022Comments Share v 11 ~ A A E Insert Calibri E ap Wrap Text General cli LA Delete v Paste BIUV A Merge & Center $ ~ % 9 Conditional Format as Cell Sort & Find & Analyze Formatting Table Styles Format Filter ~ Select Data Clipboard Font Alignment Number Styles Cells Editing Analysis A POSSIBLE DATA LOSS Some features might be lost if you save this workbook in the comma-delimited (.csv) format. To preserve these features, save it in an Excel file format. Don't show again Save As... X 41 X V fx Satis 1 S T U V W X Y Z AA AB AC AD AE AF AG AH Al AJ AK L 3 3.416667 5.875 w uI O 2 3.333333 5.125 UT 4.5 4.875 AMANNN 6 5.166667 5.625 5.5 4.625 HAWNUNNNA 3 4.583333 5.375 3 4.333333 5.75 6 6.416667 6.875 SAW A DO U Q A WAD WWN UIUI A O V WNUTUTO DAO A NAW! AU AN H WN AUTO A WOUANN 6 5.583333 6.625 P 5.5 46 5 3.916667 ON 6.75 h N N N W WANNAWW 4.5 0o 3.75 3 4.083333 .75 1.5 50 6.125 5.25 1.5 4 5.083333 52 Correlation and Regression Data 10096 Ready K? Accessibility: UnavailableA1 X Satis 1 AO AP AQ AR AS AT A AB AC AD AE AF AG AH Al AJ AK AL AM AN 2.4 T 5.875 D N 3.6 W 5.125 NNN NNHUN 1.8 A N N WNO 4.875 2.5 5.625 NN .4 4.625 NW 5.375 NA 5.75 6.875 N W U W A W N H N WN NO NNNN. W W N H W N N H W W N W O N N NN! W N N W N H N H U W N W N NHAN A W N W J O N H A W N W N N NAW J D N N W N H N H O W N W N N N AN IWODOUNOOOVOUDAUDO 6.625 2.6 6.625 AWUTWNHNNUIWNN ONNWNANHAWN 6.75 I UINUIWNYWHAW 5.875 10 00 - 5.875 NNNWWAN 0o o io in 4.75 6.125 A 4.5 52 Correlation and Regression Data (+Share v Calibri v 11 AA BE 20 V de Wrap Text Insert General E . AP O (di Paste Delete BIU vaVA EE E Merge & Center ~ $ ~ % 9 08 8 Conditional Format as Cell Sort & Find & Analyze Formatting " Table Styles ~ Format Filter ~ Select Data Clipboard Font Alignment Number IS Styles Cells Editing Analysis i POSSIBLE DATA LOSS Some features might be lost if you save this workbook in the comma-delimited (.csv) format. To preserve these features, save it in an Excel file format. Don't show again Save As... X A1 X V Satis 1 C D F F G H K M N O P O R S A B 52 5 3.333333 53 1 1.833333 PH NW 3 3.166667 WUT DAD UT 4 4.333333 WNOADDDO AD 5.25 1 4.416667 UI UT UI N W O UT N W W V 2 4.833333 4 5.333333 1 2.916667 HNW NUA A JAW AA UW W N WUT UI UI N O O W O O O W U P O O A A NN WA W O a P O UT O UT O O O O UT A N N A UI N U U W UT UT UT N UT UT W UT A W N UT W U NU O O O W O A O O UT O A A NA W U N UT UI Un UT W O N O UT UT UT A D NA 5 5.916667 5 4.833333 W NW WUT WUT HWAWNA A 5 5.583333 UT W W O UT UT O O W A NADDADUWONA w a w a a un a aw 4 5.083333 UT W WUT UT W A WAWADWUT 3 5.166667 1 2.833333 3 4.666667 68 2 3.333333 N 69 4 Correlation and Regression Data (+) - 100% Ready ?Accessibility: UnavailableZY x Delete Paste $ ~ % 9 00 .00 Conditional Format as Cell Sort & Find & Analyze BIUY BEE E Merge & Center Formatting " Table Styles Format Filter ~ Select Data Clipboard IS Font Alignment Number Styles Cells Editing Analysis POSSIBLE DATA LOSS Some features might be lost if you save this workbook in the comma-delimited (.csv) format. To preserve these features, save it in an Excel file format. Don't show again Save As... A1 X V Satis 1 AC AF AG AH Al AJ AK AD AE S T U V W X Y Z AA AB 4.5 A 52 4 5.083333 6.375 53 4 4 NAD 3.5 2 3.416667 in 5 4.083333 .5 ONNNNWHON 75 WUINWNNWHO 6 4.5 5.125 VWNWWNAANDO 4 3.583333 4 3.333333 4 4.333333 6.3 U D O UT UT UT UT UT O UT A UT UT W W A UT A H N W N U A A Q D W A D UT W W N W UT + N W A O UT O W U O UT A WO O A AUTO 6 4.416667 in 6 5.25 WN NUT AW A VA A W WWA 6 4.666667 2. 6 4.083333 NNNANNNOW NNNNNNNN 4.75 4.666667 WUT W A W W D 5.5 UW NUT UT 3.5 5.875 3.25 68 6.75 4 69 Correlation and Regression Data + 100% 1:03 PM Ready ? Accessibility: UnavailableFile Home Insert Page Layout Formulas Data Review View Help Comments 12 Share Insert Calibri 11 ~ AA ap Wrap Text General Ex A O x Delete Paste BIU $ ~ % 9 78 .00 Conditional Format as Cell Sort & Find & Analyze Merge & Center ~ Formatting ~ Table Styles Format Filter ~ Select Data Clipboard Font Alignment Number Styles Cells Editing Analysis i POSSIBLE DATA LOSS Some features might be lost if you save this workbook in the comma-delimited (.csv) format. To preserve these features, save it in an Excel file format. Don't show again Save As... X Al X fx Satis 1 AC AD AE AF AG AH Al A AK AL AM AN AO AP AQ AR AS AT AU 52 3 4 4 4.5 w 3.8 w 53 6 6.375 5.8 54 NWHOA ;.5 3.1 5 .5 2.5 JOHN N NW HUA 5.75 2.8 5.125 N w 4.75 NWUNWN 4.5 UNUI N A O A V V O UT O UT UT A D UT UT N N U H N A NO OO N N W WW HOO N HUH N W N N W U NA N N WUON J N N P N N NOW O N N N NWHON N H UP N N N AN UN N N N WHO N HUH N N N N N J N N W N WHO 6.375 UI N U H N N N W O O N N U W WA NENHWNNNWANUNNWA 5.5 2.2 5.875 2.875 NHUHNANAN in NNNNNN 1.1 4.1 5.5 1.5 68 5.875 2.6 69 6.75 Correlation and Regression Data (+ + 100% Ready 7? Accessibility: Unavailable 1:04 PMreserve these features, save it in an Excel file format. Don't show again Save As... X A1 X V fx Satis 1 A C D F F G H K L M N O P O R S 53 1 1.833333 54 3 3.166667 4 4.333333 W 5.25 WNADDAW UI W W W UT D DA 1 4.416667 2 4.833333 A D UTWO NAD WADHN 4 5.333333 Q W A UI UT UI N W O UI N W W 1 2.916667 5 5.916667 U H N W NUT A D O A W A D UT W W N W UT W N O UT UT W UT W UT UT W UT N A O A W UT UT W W O UT UT O OI W A W N O A A AP V W O W O O U O O O W O U U O U U N U U U N O O W O O O W UT A O O A AN U W A W O O A O UT O UT O O O O UT A N O W U N UT UT UT UT W O N O UT UI UI A A N V A UN U U W U U U N UT UT W UT D WN UT 4.833333 5 5.583333 WW AWADWUTUTON DAD W W N W WUT WUT H W A 4 5.083333 UT UT W W UT UT W A O D 3 5.166667 1 2.833333 3 4.666667 68 NNADD 2 3.333333 69 5 4.583333 70 Correlation and Regression Data - + 100% Ready ? Accessibility: UnavailableSave AS... POSSIBLE DATA LOSS Some features might be lost if you save this workbook in the comma-delimited (.csv) format. To preserve these features, save it in an Excel file format. Don't show again X V fx Satis 1 AF AG AH Al AJ AK A 4 T U V W X Y Z AA AB AC AD AE 6 6.375 6 4 4 6 6 W O 3.5 2 3.416667 5.5 5 4.083333 5.5 4 5.75 4.5 D D WWW ADNA 5.125 4 3.583333 4.75 4 3.333333 4.5 4 4.333333 6.375 N N N A N N N U W O N N N N WHO 6 4.416667 H N N N A N N NN WUNUNNWA UT UT A O UT UT UT UT UT OF UT D UT UT W W A UT W W UT W D W W A V W N W W N D AND U H N W N UT D D O D W D D UT W W N W NVANUAUOOPODOONO 6 5.25 .875 N NW A O UT O WUD UP WOO 6 4.666667 6 4.083333 4.75 5 4.666667 W W N N UTD WAS .5 5.875 UI W N 3.25 5.75 4 6.25 4.083333 Correlation and Regression Data + O + 100% 1:04 PM dy ? Accessibility: Unavailable 91.FFont Styles Clipboard IN Alignment N Number Cells Editing Analysis Don't show again Save As... X i POSSIBLE DATA LOSS Some features might be lost if you save this workbook in the comma-delimited (.csv) format. To preserve these features, save it in an Excel file format. A1 X V Satis1 A AJ AK AL AM AN AO AP AQ AR AS AT AB AC AD AE AF AG AH 5.8 53 6 6.375 1.7 54 3.5 3.1 55 5.5 2.5 56 5.5 2.8 CONNWWWHO 5.75 UNWNNWA 5.125 UN ANUNNNNWHO 4.75 4.5 6.375 HUNUIN A O A VVOUT OUTUTA A UT UNNANNNOWNNNNWA H N B U H N A N A N O H N N N W HU H N H U H N N N N N V N N W N WHO HUNUNNNNWONNUWWA H N B UP N W N N W UN A N N WHO H N H N H W N N N W A NUNNWHU 98929898607 5.875 2.875 i i w N 5.5 HNNNNNNNW HNNUHNANA HNHUBNN in 5.875 2.6 8 8 1 6.25 70 Correlation and Regression Data + 1009% Ready Accessibility: Unavailable 1:04 PMThe president of your company wants to better understand consumer reactions to products. For this reason, the president asked you to investigate the relationship of four consumer emotions/perceptions: purchase satisfaction, purchase disappointment, purchase regret, and repurchase intentions. To do so, you administered a survey to 100 people that bought your company's products, and the results are provided in the Correlation Database file. The survey included 12 items to gauge purchase satisfaction, 12 items to gauge purchase disappointment, 8 items to gauge purchase regret, and 10 items to gauge repurchase intentions. hs D Question 1 1 pts What is the Cronbach's alpha for the purchase satisfaction scale?D Question 2 1 pts What is the Cronbach's alpha for the purchase disappointment scale? D Question 3 1 pts What is the Cronbach's alpha for the purchase regret scale? D Question 4 1 ptsD Question 4 1 pts What is the Cronbach's alpha for the repurchase intentions scale? D Question 5 1 pts What is the correlation between purchase satisfaction and purchase disappointment? Question 6 1 ptsD Question 6 1 pts What is the correlation between purchase satisfaction and purchase regret? DI Question 7 1 pts What is the correlation between purchase satisfaction and repurchase intent? D Question 8 1 ptsD Question 8 1 pts What is the correlation between purchase disappointment and purchase regret? D Question 9 1 pts What is the correlation between purchase disappointment and repurchase intent?D Question 10 1 pts What is the correlation between purchase regret and repurchase intent? After you turned in your report on the correlations of four consumer emotions/perceptions, the president of your company went to a conference and learned about regression. Of course, the president did not pay enough attention to learn how to perform a regression, but the president now wants you to reanalyze the data that you already analyzed. Once again, you are to investigate the relationship of four consumer emotions/perceptions: purchase satisfaction, purchase disappointment, purchase regret, and repurchase intentions. To do so, you will again use the same dataset.Question 11 1 pts Conduct a regression with only purchase satisfaction predicting repurchase intent. What is the standardized beta of purchase satisfaction? D Question 12 1 pts Was this result statistically significant? O No O YesD Question 13 1 pts Conduct a regression with only purchase disappointment predicting repurchase intent. What is the standardized beta of purchase disappointment? D Question 14 1 pts Was this result statistically significant? O Yes O NoD Question 15 1 pts Conduct a regression with only purchase regret predicting repurchase intent. What is the standardized beta of purchase regret? D Question 16 1 pts Was this result statistically significant? O Yes O NoD Now, perform one regression with all three predictors (satisfaction, disappointment, and regret) and repurchase intent as the outcome. D Question 17 1 pts What is the standardized beta of purchase satisfaction? D Question 18 1 pts Was this result statistically significant?D Question 18 1 pts Was this result statistically significant? O No Yes D Question 19 1 pts What is the standardized beta of purchase disappointment? D Question 20 1 pts102 164/take Question 20 1 pts Was this result statistically significant? O No O Yes DI Question 21 1 pts What is the standardized beta of purchase regret?What is the standardized beta of purchase regret? D Question 22 1 pts Was this result statistically significant? O No Yes