2 3 4 A B You presented your analysis on fixed versus variable rate mortgage amounts...

 

Transcribed Image Text:

2 3 4 A B You presented your analysis on fixed versus variable rate mortgage amounts and it becomes clear to the management team that the issue may be bigger if there are differences between fixed and variable rate morgages by term. Some of the short-term mortgages coming due will mean individuals have to refinance at much higher rates. You advise that you can do some additional analysis by gathering data for each mortgage type categorized by term. You randomly select 10 fixed rate mortgages and 10 variable rate mortgages grouped by term (1,3,5, and 10 year). a. Provide a visual (or visuals) representation of the data. 5 b. State your null and alternative hypothesis. 6 c. Run the appropriate test. 7 d. Interpret the results. 8 9 10 1 Year Term 3 Year Term 5 Year Term 10 Year Term 11 Fixed Variable Fixed Variable Fixed Variable Fixed Variable 12 242 351 362 420 281 437 252 311 13 285 460 252 357 204 378 368 260 14 330 340 333 379 447 320 445 263 15 438 472 385 445 389 366 348 396 16 232 465 361 410 322 275 449 286 17 366 431 334 373 350 382 271 288 18 441 306 369 420 351 471 409 276 19 381 263 352 401 259 382 254 472 20 383 336 341 324 278 323 287 459 21 395 317 265 404 277 341 316 416 2 3 4 A B You presented your analysis on fixed versus variable rate mortgage amounts and it becomes clear to the management team that the issue may be bigger if there are differences between fixed and variable rate morgages by term. Some of the short-term mortgages coming due will mean individuals have to refinance at much higher rates. You advise that you can do some additional analysis by gathering data for each mortgage type categorized by term. You randomly select 10 fixed rate mortgages and 10 variable rate mortgages grouped by term (1,3,5, and 10 year). a. Provide a visual (or visuals) representation of the data. 5 b. State your null and alternative hypothesis. 6 c. Run the appropriate test. 7 d. Interpret the results. 8 9 10 1 Year Term 3 Year Term 5 Year Term 10 Year Term 11 Fixed Variable Fixed Variable Fixed Variable Fixed Variable 12 242 351 362 420 281 437 252 311 13 285 460 252 357 204 378 368 260 14 330 340 333 379 447 320 445 263 15 438 472 385 445 389 366 348 396 16 232 465 361 410 322 275 449 286 17 366 431 334 373 350 382 271 288 18 441 306 369 420 351 471 409 276 19 381 263 352 401 259 382 254 472 20 383 336 341 324 278 323 287 459 21 395 317 265 404 277 341 316 416