G11 Name Box X fx A B D E F F G H I 2 3 Real Value Pty. Ltd. 4 Note: As a backup, you are advised to save and use this file under another name. 5 6 Database: Random Sample of 150 Real Value Pty Ltd business data, Year Ended June 30 7 8 Variable Name and Description: 9 Sales Sm: Total Sales revenue for each supermarket for the financial year. $ million. 10 Wages $m: Total Wage and salary bill for the financial year. Smillion 11 Wages %: Total Wage bill as a percentage of Total income. 12 No. Staff: The number of effective full-time staff employed on a weekly basis. 13 Operating level If number of staff is : (0-50 = Less active, 50-75 = Moderately active, 75-150 Highly active) 14 State: Stores surveyed in different states 15 1 = Australian Capital Territory (ACT) 3 = Northern Territory (NT) 16 2 = New South Wales (NSW) 4 = Queensland (Qld) 17 Ago (Yrs); The number of full years of operation of the store. 18 GrossProfit: Gross Profit for each supermarket for the financial year. $000. 19 Adv.$'000: Advertising and promotional expenses for the financial year, $'000 20 Competitors: The number of competing supermarkets in the consumer catchment area 21 Hrs Trading The total number of hours open for trading per week 22 23 24 25 26 27 28 Assignment Home Insert Page Layout Formulas Data Review View Cut 10 A- A- Wrap Text Ge Copy MS Sans Serif B I u Paste 5 Merge & Center MO Format P16 fx C 3 4 5 6 7 8 9 G H State State (Num) ACT 1 ACT 1 ACT 1 ACT 1 ACT 1 ACT 1 ACT 1 ACT 1 ACT 1 ACT 1 ACT 1 ACT 1 ACT 1 ACT 1 ACT 1 ACT 1 ACT 1 ACT 1 ACT 1 J K M Age (Yrs) GrossProfit $ 000 Adv.5'000 CompetitorsHrs Trading 8 37.200 77 5 127 6 44.100 105 6 160 1 314.100 132 0 65 B 30.100 90 5 127 5 109.700 201 5 160 6 51.700 300 2 88 1 169.700 109 1 76 4 74.900 4 119 13 149.600 88 2 90 11 259.300 85 2 93 46.500 37 3 2 289.500 31 11 45.200 73 4 122 12 112.100 90 3 100 10 181.400 90 3 5 76.700 19 4 109 2 142.400 120 2 90 5 135.300 169 2 93 14 44.900 72 4 114 10 11 12 13 14 15 16 17 18 19 20 21 22 138 103 102 6 2 23 113 134 103 23 24 25 26 27 28 29 30 159 1 1 4 B D E F Store No. Sales Sm Wages Sm Wages % No. Staff Operating level 75 7.2 3.5 18.5 32 Les active 78 10.9 3.9 16.1 Les active 52 6.9 3.8 22.6 46 Les active 150 9.8 3.9 17.6 53 Moderately active 90 13.0 4.3 16.3 63 Moderately active 12 17.5 4.8 15.0 67 Moderately active 92 5.8 3.5 23.1 35 Les active 83 5.7 3.3 19.8 36 Les active 128 7.3 3.5 18.7 37 Les active 137 7.6 3.5 17.8 37 Les active 7.7 3.6 18.8 37 Les active 86 5.9 3.6 23.4 39 Les active 95 7.2 3.6 20.1 Les active 106 3.4 20.1 42 Les active 80 7.6 3.7 19.7 43 Les active 29 7.8 3.6 18.5 44 Les active 50 8.8 3.7 18.0 44 Les active 61 9.2 3.9 19.0 Les active 139 3.8 22.7 44 Les active 119 10.0 3.5 13.9 46 Les active 69 9.8 4.0 18.7 48 Les active 91 5.5 3.6 24.9 49 Les active 71 10.6 4.3 19.7 50 Moderately active 109 7.0 3.8 22.9 51 Moderately active 147 6.3 3.4 20.4 51 Moderately active 8 13.1 4.2 15.5 52 Moderately active 1 10.7 4.0 17.3 53 Moderately active 25 8.7 4.0 21.1 53 Moderately active 94 11.1 3.8 15.3 53 Moderately active 99 10.7 4.2 18.7 53 Moderately active 7 11.3 4.1 17.2 54 Moderately active 16 8.0 3.8 20.8 55 Moderately active 131 7.3 3.9 23.1 55 Moderately active 82 14.1 4.2 14.4 59 Moderately active 18 14.4 4.3 15.3 60 Moderately active 101 10.7 4.1 18.6 60 Moderately active 124 14.4 4.6 17.2 60 Moderately active 81 12.2 4.2 16.5 Moderately active 103 9.3 4.2 21.8 Moderately active 20 10.4 4.3 20.1 Moderately active 67 11.6 19.3 Moderately active 66 10.6 4.9 24.8 Moderately active 45 12.6 4.8 20.3 76 Highly active 144 14.1 5.1 20.4 Highly active 22 15.0 4.7 16.6 79 Highly active 96 16.4 5.3 19.0 81 Highly active 23 10.0 3.7 15.9 44 Les active 105 7.5 3.6 19.2 48 Les active 32 11.3 4.2 18.5 54 Moderately active 115 19.2 5.0 14.8 82 Highly active 12 18 5 9 2 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 2 117 8 202 159 89 166 200 112 124 ACT ACT ACT ACT ACT ACT ACT ACT ACT ACT ACT ACT ACT ACT ACT ACT ACT ACT NSW NSW NSW NSW NSW NSW NSW NSW NSW NSW NSW NSW NSW 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 111 218 2 3 3 2 1 2 4 6 5 0 3 0 5 2 178.100 100.800 182.900 174.500 113.300 71.600 96.900 98.100 108.200 134.100 174.900 93.100 85.700 69.300 36.100 217.700 112.500 90.600 56.000 67.700 39.000 154.900 140.400 120.500 152.800 255.300 168.100 106.800 35.400 122.900 34.400 93 106 79 83 125 131 87 102 98 93 78 92 113 160 129 65 104 68 124 88 74 88 90 103 76 72 175 16 6 15 22 8 7 9 8 4 19 12 4 18 21 8 7 11 7 10 6 NNNN 2 2 2 2 2 79 176 170 163 104 129 202 191 163 189 270 84 113 201 284 1 NN NNN OON 137 160 93 129 2 5 5 P16 Jx A B D E F G H 1 J K L M N 3 NNN 11 3 3 1 1 0 21.8 21.8 24.4 20.8 22.3 22.4 25.7 22.6 23.2 24.1 2 112 82 78 74 104 142 NN 55 114 54 74 84 104 5 89 118 145 41 108 127 39 47 51 70 98 130 21 116 100 56 92 61 59 65 100 89 97 106 87 15 3 14 3 17 2 12 3 2 2 2 2 2 2 4 5 6 -7 8 -9 -0 1 2 3 4 5 -6 -7 8 -9 "O "1 2 3 4 5 "6 7 18 2 5 0 2 3 3 3 1 2 0 1 0 2 3 92 103 107 102 78 82 122 NNNNN 71 139 134 8 3 B 34 35 37 40 42 42 44 44 44 44 46 46 46 47 49 49 49 49 51 58 58 59 60 72 75 84 92 37 37 37 39 76 5.4 6.1 5.0 6.6 6.3 6.5 5.8 5.6 5.7 6.1 7.2 8.9 6.9 12.7 10.3 9.1 10.0 7.0 4.8 9.3 10.9 16.4 13.8 18.6 9.9 13.0 17.7 6.2 5.6 4.8 6.0 4.1 5.8 6.2 5.4 8.7 7.7 2 2 2 2 2 2 2 1 2 16 2 5 6 12 6 NSW NSW NSW NSW NSW NSW NSW NSW NSW NSW NSW NSW NSW NSW NSW NSW NSW NSW NSW NSW NSW NSW NSW NSW NSW NSW NSW NSW NSW NSW NSW NSW NSW NSW NT NT NT NT 187 74 88 132 153 6 4 1 275 3.3 3.5 3.4 3.5 3.6 3.6 3.7 3.5 3.5 3.7 3.6 3.7 3.5 4.1 4.2 4.0 4.3 3.7 3.3 4.1 3.9 4.3 4.7 5.0 4.7 5.3 5.5 3.5 3.5 3.4 3.8 3.6 3.5 3.6 3.6 4.0 4.2 4.3 4.6 4.3 4.7 5.0 5.0 5.0 5.0 5.3 5.6 5.4 5.1 3.4 3.7 1 Les active Les active Les active Les active Les active Les active Les active Les active Les active Les active Les active Les active Les active Les active Les active Les active Les active Les active Moderately active Moderately active Moderately active Moderately active Moderately active Moderately active Highly active Highly active Highly active Les active Les active Les active Les active Les active Les active Les active Les active Moderately active Moderately active Moderately active Moderately active Moderately active Moderately active Moderately active Moderately active Moderately active Highly active Highly active Highly active Highly active Highly active Les active Les active 90 92 128 160 132 77 83 129 139 78 77 168 272 190 152 357 57 5 5 1. 2 114.800 155.200 157.900 178.100 125.200 39.300 241.700 135.200 50.000 173.300 110.900 128.700 146.900 172.500 280.500 226.800 141.100 76.500 76.500 42.800 116.800 164.100 173.000 40.000 115.700 223.700 155.700 144.900 124.300 38.400 175.000 28.700 80.100 126.900 39.200 43.600 100.300 130.500 168.500 176.500 129.300 219.600 189.300 81.500 77.300 110.000 124.300 35.300 37.300 34.100 89.500 1 105 17.4 20.2 15.4 19.4 19.9 20.7 21.8 22.9 20.3 16.7 13.4 17.9 15.0 24.8 23.2 18.6 21.5 22.9 24.6 25.7 30.7 22.8 22.2 25.9 20.8 25.1 22.2 22.1 21.8 20.2 21.5 35.0 39.4 22.6 30.4 23.1 21.9 21.1 18.2 19.9 NNN NNNN 62 122 136 46 17 33 36 141 133 40 63 19 121 37 53 31 140 56 79 107 14 72 146 120 8 2 11 1 16 1 1 0 1 5 2 58 114 65 99 0 -1 2 3 -4 5 6 -7 8 9 0 1 2 3 4 5 6 7 8 9 00 01 2 03 34 86 129 89 142 112 82 124 112 103 2 11 3 14 20 13 12 3 17 101 69 140 185 1 5 4 3 0 1 1 11.0 197 43 44 49 51 55 63 63 65 67 67 71 72 81 89 91 95 110 32 47 127 163 237 12.2 13.0 7.3 6.3 12.3 9.6 14.3 14.5 13.5 7.1 7.9 0 2 0 4 136 5 2 1 4 0 4 NT NT NT NT NT 77 76 70 70 65 121 116 101 83 146 137 147 99 110 241 187 189 237 241 104 39 2 11 1 6 6 30 44 113 110 1 1 2 B D E F G H 1 J K L M 13.6 12.2 12.6 5 4 60 43 97 26 1 2 80 91 121 93 $ 13 2 1 1 3 129 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 4 58 48 35 73 87 10 57 4.1 4.2 4.7 3.3 3.5 3.5 3.5 3.6 3.7 3.7 3.6 3.8 3.7 3.6 4.0 3.7 3.6 3.9 3.9 14.7 17.0 20.1 24.3 21.4 17.5 19.9 23.1 18.1 20.0 21.6 21.6 20.5 18.6 15.7 22.9 20.4 20.1 15.2 13.5 20.7 17.4 18.7 3 3 3 3 3 3 3 3 3 3 3 3 3 3 NT NT NT NT NT NT NT NT NT NT NT NT NT NT Qld Qld Old Old Qld Old Old Qld Qld Old Old Qld 44 46 46 46 48 48 48 49 49 49 49 51 55 55 56 197 184 144 70 111 101 48 109 57 98 113 142 138 21 122 116 57 35 145 226 1 1 3 5 3 2 3 1 111 77 110 115 70 80 101 127 100 92 104 1 3 18 20 15 13 3 6 13 2 10 5 5 10 11 24 49 4 4 4 1 79 103 4 4 3 2 0 2 3 69 88 108 4 4 4 128 2 3.8 4.2 3.6 3.9 3.9 4.0 4.1 4.5 4 Moderately active Moderately active Moderately active Les active Les active Les active Les active Les active Les active Les active Les active Les active Les active Les active Les active Les active Les active Les active Moderately active Moderately active Moderately active Moderately active Moderately active Moderately active Moderately active Moderately active Moderately active Moderately active Moderately active Moderately active Moderately active Moderately active Moderately active Les active Les active Les active Les active Les active Moderately active Moderately active Moderately active Moderately active Moderately active Moderately active Moderately active Highly active Highly active Highly active Highly active 6.3 7.9 6.8 6.2 8.6 7.7 6.7 7.4 7.6 7.9 12.2 6.6 7.2 8.5 11.5 16.7 7.9 12.0 8.0 8.5 8.7 9.6 12.1 13.9 14.9 12.7 13.7 15.2 17.2 6.1 8.5 7.6 8.6 8.2 9.6 10.2 8.9 15.3 11.8 11.4 15.3 15.1 14.0 21.7 4 129 130 131 132 133 134 135 136 137 8 6 8 189.200 142.800 88.100 124.500 187.600 223.200 191.300 68.600 158.400 156.400 83.700 33.400 92.400 165.300 118.000 156.800 167.300 56.100 67.200 228.800 142.100 88.100 180.800 241.300 85.900 54.400 255.400 226.400 262.100 36.000 45.400 126.400 134.400 164.900 215.000 151.700 90.500 143.700 160.500 120.600 114.800 120.600 288.900 210.500 108.800 188.100 126.900 128.700 98.000 4 136 103 85 109 127 188 216 197 201 154 173 4 61 93 135 100 6 132 68 123 11 112 125 134 15 143 2 76 142 3 28 85 117 77 149 64 38 88 9 148 102 59 27 42 65 126 92 100 116 116 78 67 126 125 91 4 3 7 3 4 4.8 4.7 4.8 1 0 5 5 2 2 1 & & & & & & & & & & & 6 5 243 138 3.2 4 53 4 19.7 19.6 16.6 16.6 17.1 17.6 18.8 16.8 15.5 17.6 19.6 18.9 19.1 18.5 20.3 18.2 19.9 14.8 20.7 20.3 15.8 19.3 21.0 14.3 16.8 80 139 140 141 142 143 144 68 72 28 42 42 44 48 51 53 55 3.8 3.6 3.8 3.7 4.1 4.0 3.9 4 80 77 90 104 106 106 Old 4 1 Qld Old 145 3 Old 4 7 7 16 14 4 11 2 3 3 2 3 3 3 2 0 1 4 2 2 2 108 138 199 106 203 91 157 254 299 271 336 146 147 148 149 150 151 152 153 4 104 100 104 94 77 84 116 4.6 4.5 4.6 5.1 5.2 5.3 4.9 Qld Qld 4 Qld 4 90 91 16.5 Old 4 5 220 D Q Confidence interval for sales $m Conclusion 4 Less active Moderately active Highly active Confidence Intervals Lower limit Upper limit S # ta/2,n-1 su stta/2, n-1 Vn n G H J L M N 0 P Q R S T Confidence intervals Conclusion ACT NSW NT OLD A A B D E F G 1 K L M N 0 Q Probability of Profit 03a NSW 08 NSW ACT NT OLD Profit ACT NT OLD 03b NSW Probability of Profit ACT NT QLD B D E F H 1 J K L M N. N 0 P 0 Q R S T U Null Hypotesis Alternative Hypothesis Mean (4) Conclusion 4(a) 04a Critical Values ACT Test statistic ACT NSW NT QLD Profit ACT NSW NT QLD NSW NT QLD 4(b) 4(b) ACT NSW NT QLD Conclusion Crtical Value Test Statistic Profit ACT NSW NT QLD Test Satistic Conclusion Q4b Vull Hypotesis Proportions ACT NSW NT QLD TOTAL Alternative Hypothesis TC Level of Significance For a PROPORTION (Tt), the CRITICAL VALUE is the z-score Confidence Interval Level of Significance Critical Value of Z ( (a) One Tail Two Tails G11 Name Box X fx A B D E F F G H I 2 3 Real Value Pty. Ltd. 4 Note: As a backup, you are advised to save and use this file under another name. 5 6 Database: Random Sample of 150 Real Value Pty Ltd business data, Year Ended June 30 7 8 Variable Name and Description: 9 Sales Sm: Total Sales revenue for each supermarket for the financial year. $ million. 10 Wages $m: Total Wage and salary bill for the financial year. Smillion 11 Wages %: Total Wage bill as a percentage of Total income. 12 No. Staff: The number of effective full-time staff employed on a weekly basis. 13 Operating level If number of staff is : (0-50 = Less active, 50-75 = Moderately active, 75-150 Highly active) 14 State: Stores surveyed in different states 15 1 = Australian Capital Territory (ACT) 3 = Northern Territory (NT) 16 2 = New South Wales (NSW) 4 = Queensland (Qld) 17 Ago (Yrs); The number of full years of operation of the store. 18 GrossProfit: Gross Profit for each supermarket for the financial year. $000. 19 Adv.$'000: Advertising and promotional expenses for the financial year, $'000 20 Competitors: The number of competing supermarkets in the consumer catchment area 21 Hrs Trading The total number of hours open for trading per week 22 23 24 25 26 27 28 Assignment Home Insert Page Layout Formulas Data Review View Cut 10 A- A- Wrap Text Ge Copy MS Sans Serif B I u Paste 5 Merge & Center MO Format P16 fx C 3 4 5 6 7 8 9 G H State State (Num) ACT 1 ACT 1 ACT 1 ACT 1 ACT 1 ACT 1 ACT 1 ACT 1 ACT 1 ACT 1 ACT 1 ACT 1 ACT 1 ACT 1 ACT 1 ACT 1 ACT 1 ACT 1 ACT 1 J K M Age (Yrs) GrossProfit $ 000 Adv.5'000 CompetitorsHrs Trading 8 37.200 77 5 127 6 44.100 105 6 160 1 314.100 132 0 65 B 30.100 90 5 127 5 109.700 201 5 160 6 51.700 300 2 88 1 169.700 109 1 76 4 74.900 4 119 13 149.600 88 2 90 11 259.300 85 2 93 46.500 37 3 2 289.500 31 11 45.200 73 4 122 12 112.100 90 3 100 10 181.400 90 3 5 76.700 19 4 109 2 142.400 120 2 90 5 135.300 169 2 93 14 44.900 72 4 114 10 11 12 13 14 15 16 17 18 19 20 21 22 138 103 102 6 2 23 113 134 103 23 24 25 26 27 28 29 30 159 1 1 4 B D E F Store No. Sales Sm Wages Sm Wages % No. Staff Operating level 75 7.2 3.5 18.5 32 Les active 78 10.9 3.9 16.1 Les active 52 6.9 3.8 22.6 46 Les active 150 9.8 3.9 17.6 53 Moderately active 90 13.0 4.3 16.3 63 Moderately active 12 17.5 4.8 15.0 67 Moderately active 92 5.8 3.5 23.1 35 Les active 83 5.7 3.3 19.8 36 Les active 128 7.3 3.5 18.7 37 Les active 137 7.6 3.5 17.8 37 Les active 7.7 3.6 18.8 37 Les active 86 5.9 3.6 23.4 39 Les active 95 7.2 3.6 20.1 Les active 106 3.4 20.1 42 Les active 80 7.6 3.7 19.7 43 Les active 29 7.8 3.6 18.5 44 Les active 50 8.8 3.7 18.0 44 Les active 61 9.2 3.9 19.0 Les active 139 3.8 22.7 44 Les active 119 10.0 3.5 13.9 46 Les active 69 9.8 4.0 18.7 48 Les active 91 5.5 3.6 24.9 49 Les active 71 10.6 4.3 19.7 50 Moderately active 109 7.0 3.8 22.9 51 Moderately active 147 6.3 3.4 20.4 51 Moderately active 8 13.1 4.2 15.5 52 Moderately active 1 10.7 4.0 17.3 53 Moderately active 25 8.7 4.0 21.1 53 Moderately active 94 11.1 3.8 15.3 53 Moderately active 99 10.7 4.2 18.7 53 Moderately active 7 11.3 4.1 17.2 54 Moderately active 16 8.0 3.8 20.8 55 Moderately active 131 7.3 3.9 23.1 55 Moderately active 82 14.1 4.2 14.4 59 Moderately active 18 14.4 4.3 15.3 60 Moderately active 101 10.7 4.1 18.6 60 Moderately active 124 14.4 4.6 17.2 60 Moderately active 81 12.2 4.2 16.5 Moderately active 103 9.3 4.2 21.8 Moderately active 20 10.4 4.3 20.1 Moderately active 67 11.6 19.3 Moderately active 66 10.6 4.9 24.8 Moderately active 45 12.6 4.8 20.3 76 Highly active 144 14.1 5.1 20.4 Highly active 22 15.0 4.7 16.6 79 Highly active 96 16.4 5.3 19.0 81 Highly active 23 10.0 3.7 15.9 44 Les active 105 7.5 3.6 19.2 48 Les active 32 11.3 4.2 18.5 54 Moderately active 115 19.2 5.0 14.8 82 Highly active 12 18 5 9 2 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 2 117 8 202 159 89 166 200 112 124 ACT ACT ACT ACT ACT ACT ACT ACT ACT ACT ACT ACT ACT ACT ACT ACT ACT ACT NSW NSW NSW NSW NSW NSW NSW NSW NSW NSW NSW NSW NSW 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 111 218 2 3 3 2 1 2 4 6 5 0 3 0 5 2 178.100 100.800 182.900 174.500 113.300 71.600 96.900 98.100 108.200 134.100 174.900 93.100 85.700 69.300 36.100 217.700 112.500 90.600 56.000 67.700 39.000 154.900 140.400 120.500 152.800 255.300 168.100 106.800 35.400 122.900 34.400 93 106 79 83 125 131 87 102 98 93 78 92 113 160 129 65 104 68 124 88 74 88 90 103 76 72 175 16 6 15 22 8 7 9 8 4 19 12 4 18 21 8 7 11 7 10 6 NNNN 2 2 2 2 2 79 176 170 163 104 129 202 191 163 189 270 84 113 201 284 1 NN NNN OON 137 160 93 129 2 5 5 P16 Jx A B D E F G H 1 J K L M N 3 NNN 11 3 3 1 1 0 21.8 21.8 24.4 20.8 22.3 22.4 25.7 22.6 23.2 24.1 2 112 82 78 74 104 142 NN 55 114 54 74 84 104 5 89 118 145 41 108 127 39 47 51 70 98 130 21 116 100 56 92 61 59 65 100 89 97 106 87 15 3 14 3 17 2 12 3 2 2 2 2 2 2 4 5 6 -7 8 -9 -0 1 2 3 4 5 -6 -7 8 -9 "O "1 2 3 4 5 "6 7 18 2 5 0 2 3 3 3 1 2 0 1 0 2 3 92 103 107 102 78 82 122 NNNNN 71 139 134 8 3 B 34 35 37 40 42 42 44 44 44 44 46 46 46 47 49 49 49 49 51 58 58 59 60 72 75 84 92 37 37 37 39 76 5.4 6.1 5.0 6.6 6.3 6.5 5.8 5.6 5.7 6.1 7.2 8.9 6.9 12.7 10.3 9.1 10.0 7.0 4.8 9.3 10.9 16.4 13.8 18.6 9.9 13.0 17.7 6.2 5.6 4.8 6.0 4.1 5.8 6.2 5.4 8.7 7.7 2 2 2 2 2 2 2 1 2 16 2 5 6 12 6 NSW NSW NSW NSW NSW NSW NSW NSW NSW NSW NSW NSW NSW NSW NSW NSW NSW NSW NSW NSW NSW NSW NSW NSW NSW NSW NSW NSW NSW NSW NSW NSW NSW NSW NT NT NT NT 187 74 88 132 153 6 4 1 275 3.3 3.5 3.4 3.5 3.6 3.6 3.7 3.5 3.5 3.7 3.6 3.7 3.5 4.1 4.2 4.0 4.3 3.7 3.3 4.1 3.9 4.3 4.7 5.0 4.7 5.3 5.5 3.5 3.5 3.4 3.8 3.6 3.5 3.6 3.6 4.0 4.2 4.3 4.6 4.3 4.7 5.0 5.0 5.0 5.0 5.3 5.6 5.4 5.1 3.4 3.7 1 Les active Les active Les active Les active Les active Les active Les active Les active Les active Les active Les active Les active Les active Les active Les active Les active Les active Les active Moderately active Moderately active Moderately active Moderately active Moderately active Moderately active Highly active Highly active Highly active Les active Les active Les active Les active Les active Les active Les active Les active Moderately active Moderately active Moderately active Moderately active Moderately active Moderately active Moderately active Moderately active Moderately active Highly active Highly active Highly active Highly active Highly active Les active Les active 90 92 128 160 132 77 83 129 139 78 77 168 272 190 152 357 57 5 5 1. 2 114.800 155.200 157.900 178.100 125.200 39.300 241.700 135.200 50.000 173.300 110.900 128.700 146.900 172.500 280.500 226.800 141.100 76.500 76.500 42.800 116.800 164.100 173.000 40.000 115.700 223.700 155.700 144.900 124.300 38.400 175.000 28.700 80.100 126.900 39.200 43.600 100.300 130.500 168.500 176.500 129.300 219.600 189.300 81.500 77.300 110.000 124.300 35.300 37.300 34.100 89.500 1 105 17.4 20.2 15.4 19.4 19.9 20.7 21.8 22.9 20.3 16.7 13.4 17.9 15.0 24.8 23.2 18.6 21.5 22.9 24.6 25.7 30.7 22.8 22.2 25.9 20.8 25.1 22.2 22.1 21.8 20.2 21.5 35.0 39.4 22.6 30.4 23.1 21.9 21.1 18.2 19.9 NNN NNNN 62 122 136 46 17 33 36 141 133 40 63 19 121 37 53 31 140 56 79 107 14 72 146 120 8 2 11 1 16 1 1 0 1 5 2 58 114 65 99 0 -1 2 3 -4 5 6 -7 8 9 0 1 2 3 4 5 6 7 8 9 00 01 2 03 34 86 129 89 142 112 82 124 112 103 2 11 3 14 20 13 12 3 17 101 69 140 185 1 5 4 3 0 1 1 11.0 197 43 44 49 51 55 63 63 65 67 67 71 72 81 89 91 95 110 32 47 127 163 237 12.2 13.0 7.3 6.3 12.3 9.6 14.3 14.5 13.5 7.1 7.9 0 2 0 4 136 5 2 1 4 0 4 NT NT NT NT NT 77 76 70 70 65 121 116 101 83 146 137 147 99 110 241 187 189 237 241 104 39 2 11 1 6 6 30 44 113 110 1 1 2 B D E F G H 1 J K L M 13.6 12.2 12.6 5 4 60 43 97 26 1 2 80 91 121 93 $ 13 2 1 1 3 129 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 4 58 48 35 73 87 10 57 4.1 4.2 4.7 3.3 3.5 3.5 3.5 3.6 3.7 3.7 3.6 3.8 3.7 3.6 4.0 3.7 3.6 3.9 3.9 14.7 17.0 20.1 24.3 21.4 17.5 19.9 23.1 18.1 20.0 21.6 21.6 20.5 18.6 15.7 22.9 20.4 20.1 15.2 13.5 20.7 17.4 18.7 3 3 3 3 3 3 3 3 3 3 3 3 3 3 NT NT NT NT NT NT NT NT NT NT NT NT NT NT Qld Qld Old Old Qld Old Old Qld Qld Old Old Qld 44 46 46 46 48 48 48 49 49 49 49 51 55 55 56 197 184 144 70 111 101 48 109 57 98 113 142 138 21 122 116 57 35 145 226 1 1 3 5 3 2 3 1 111 77 110 115 70 80 101 127 100 92 104 1 3 18 20 15 13 3 6 13 2 10 5 5 10 11 24 49 4 4 4 1 79 103 4 4 3 2 0 2 3 69 88 108 4 4 4 128 2 3.8 4.2 3.6 3.9 3.9 4.0 4.1 4.5 4 Moderately active Moderately active Moderately active Les active Les active Les active Les active Les active Les active Les active Les active Les active Les active Les active Les active Les active Les active Les active Moderately active Moderately active Moderately active Moderately active Moderately active Moderately active Moderately active Moderately active Moderately active Moderately active Moderately active Moderately active Moderately active Moderately active Moderately active Les active Les active Les active Les active Les active Moderately active Moderately active Moderately active Moderately active Moderately active Moderately active Moderately active Highly active Highly active Highly active Highly active 6.3 7.9 6.8 6.2 8.6 7.7 6.7 7.4 7.6 7.9 12.2 6.6 7.2 8.5 11.5 16.7 7.9 12.0 8.0 8.5 8.7 9.6 12.1 13.9 14.9 12.7 13.7 15.2 17.2 6.1 8.5 7.6 8.6 8.2 9.6 10.2 8.9 15.3 11.8 11.4 15.3 15.1 14.0 21.7 4 129 130 131 132 133 134 135 136 137 8 6 8 189.200 142.800 88.100 124.500 187.600 223.200 191.300 68.600 158.400 156.400 83.700 33.400 92.400 165.300 118.000 156.800 167.300 56.100 67.200 228.800 142.100 88.100 180.800 241.300 85.900 54.400 255.400 226.400 262.100 36.000 45.400 126.400 134.400 164.900 215.000 151.700 90.500 143.700 160.500 120.600 114.800 120.600 288.900 210.500 108.800 188.100 126.900 128.700 98.000 4 136 103 85 109 127 188 216 197 201 154 173 4 61 93 135 100 6 132 68 123 11 112 125 134 15 143 2 76 142 3 28 85 117 77 149 64 38 88 9 148 102 59 27 42 65 126 92 100 116 116 78 67 126 125 91 4 3 7 3 4 4.8 4.7 4.8 1 0 5 5 2 2 1 & & & & & & & & & & & 6 5 243 138 3.2 4 53 4 19.7 19.6 16.6 16.6 17.1 17.6 18.8 16.8 15.5 17.6 19.6 18.9 19.1 18.5 20.3 18.2 19.9 14.8 20.7 20.3 15.8 19.3 21.0 14.3 16.8 80 139 140 141 142 143 144 68 72 28 42 42 44 48 51 53 55 3.8 3.6 3.8 3.7 4.1 4.0 3.9 4 80 77 90 104 106 106 Old 4 1 Qld Old 145 3 Old 4 7 7 16 14 4 11 2 3 3 2 3 3 3 2 0 1 4 2 2 2 108 138 199 106 203 91 157 254 299 271 336 146 147 148 149 150 151 152 153 4 104 100 104 94 77 84 116 4.6 4.5 4.6 5.1 5.2 5.3 4.9 Qld Qld 4 Qld 4 90 91 16.5 Old 4 5 220 D Q Confidence interval for sales $m Conclusion 4 Less active Moderately active Highly active Confidence Intervals Lower limit Upper limit S # ta/2,n-1 su stta/2, n-1 Vn n G H J L M N 0 P Q R S T Confidence intervals Conclusion ACT NSW NT OLD A A B D E F G 1 K L M N 0 Q Probability of Profit 03a NSW 08 NSW ACT NT OLD Profit ACT NT OLD 03b NSW Probability of Profit ACT NT QLD B D E F H 1 J K L M N. N 0 P 0 Q R S T U Null Hypotesis Alternative Hypothesis Mean (4) Conclusion 4(a) 04a Critical Values ACT Test statistic ACT NSW NT QLD Profit ACT NSW NT QLD NSW NT QLD 4(b) 4(b) ACT NSW NT QLD Conclusion Crtical Value Test Statistic Profit ACT NSW NT QLD Test Satistic Conclusion Q4b Vull Hypotesis Proportions ACT NSW NT QLD TOTAL Alternative Hypothesis TC Level of Significance For a PROPORTION (Tt), the CRITICAL VALUE is the z-score Confidence Interval Level of Significance Critical Value of Z ( (a) One Tail Two Tails