1. Calculate the annualized Sharpe Ratio for HORMEL FOODS.

2. Calculate the annualized Sharpe Ratio of the market portfolio.

This isn't all the data. Just need help showing how you would calculate each Sharpe Ratios.

Dustcn Hooper DH ! X Comments O assignmentdata (1) - Compatibility Mode - Excel Review View Help Search Wrap Text General 1 P D Merge & Center - $ - % ox 3 % Conditional Format as Cell Formatting - Table - Styles Alignment Number 1 - Share 4 Ideas i Paste Copy Insert Delete Format Autosum - 47 0 Sort & Find & Filter - Select- ting Cells E E F G H I J K L M N O P Q R S T A AutoSave C H2 3 , File Home Insert Draw Page Layout Formulas Data X Cut Calitri 11 A A === - 3 Formal Painter BIU-B O A . Clipboard G18 - X fo C D 1 date r et HORMEL FOODS CORP rf mkt_ret 9 260 1/9/1991 0 0.00023 -0.00927 261 1/10/1991 -0.007143 0.00023 0.00963 262 1/11/1991 -0.028777 0.00023 0.00123 263 1/14/1991 -0.017778 0.00023 -0.00987 261 1/15/1991 0 0.00023 0.00313 265 1/16/1991 0.007576 0.00023 0.01023 266 1/17/1991 0.052632 0.00023 0.03433 267 1/19/1991 0.021479 0.00023 0.00953 268 1/21/1991 -0.006993 0.00023 -0.00057 269 1/22/1991 0 0.00023 -0.00627 270 1/23/1991 -0.007042 0.00023 0.00613 271 1/24/1991 0.014184 0.00023 0.01473 272 1/25/1991 0.020979 0.00023 0.00423 273 1/28/1991 0.006849 0.00023 0.00163 274 1/29/1991 -0.027211 0.00023 0.00123 275 1/30/1991 0.006993 0.00023 0.01543 276 1/31/1991 -0.020833 0.00023 0.00973 277 2/1/1991 -0.021277 0.00025 -0.00005 278 2/4/1991 0.021739 0.00025 0.01615 279 2/5/1991 -0.007092 0.00025 0.01075 280 2/6/1991 0.021429 0.00025 0.01795 2 281 2/7/1991 0 0.00025 -0.00415 292 2/9/1991 0.006992 0.00025 0.00655 283 2/11/1991 0.013889 0.00025 0.02395 281 2/12/1991 -0.013699 0.00025 -0.00565 . > 285 2/13/1991 0.020833 0.00025 0.00915 286 2/14/1991 0.068027 0.00025 -0.01175 543 PM 287 /15/1991 -0.006364 0.00025 0.01225 Wednesday 258 -0.00641 0.00025 0.00155 4/22/2020 289 -0.006152 0.00025 -0.01035 assignmentdata 2/19/1991 2/20/1991 # - H + 100% Dustcn Hooper DH ! X Comments O assignmentdata (1) - Compatibility Mode - Excel Review View Help Search Wrap Text General 1 P D Merge & Center - $ - % ox 3 % Conditional Format as Cell Formatting - Table - Styles Alignment Number 1 - Share 4 Ideas i Paste Copy Insert Delete Format Autosum - 47 0 Sort & Find & Filter - Select- ting Cells E E F G H I J K L M N O P Q R S T A AutoSave C H2 3 , File Home Insert Draw Page Layout Formulas Data X Cut Calitri 11 A A === - 3 Formal Painter BIU-B O A . Clipboard G18 - X fo C D 1 date r et HORMEL FOODS CORP rf mkt_ret 9 260 1/9/1991 0 0.00023 -0.00927 261 1/10/1991 -0.007143 0.00023 0.00963 262 1/11/1991 -0.028777 0.00023 0.00123 263 1/14/1991 -0.017778 0.00023 -0.00987 261 1/15/1991 0 0.00023 0.00313 265 1/16/1991 0.007576 0.00023 0.01023 266 1/17/1991 0.052632 0.00023 0.03433 267 1/19/1991 0.021479 0.00023 0.00953 268 1/21/1991 -0.006993 0.00023 -0.00057 269 1/22/1991 0 0.00023 -0.00627 270 1/23/1991 -0.007042 0.00023 0.00613 271 1/24/1991 0.014184 0.00023 0.01473 272 1/25/1991 0.020979 0.00023 0.00423 273 1/28/1991 0.006849 0.00023 0.00163 274 1/29/1991 -0.027211 0.00023 0.00123 275 1/30/1991 0.006993 0.00023 0.01543 276 1/31/1991 -0.020833 0.00023 0.00973 277 2/1/1991 -0.021277 0.00025 -0.00005 278 2/4/1991 0.021739 0.00025 0.01615 279 2/5/1991 -0.007092 0.00025 0.01075 280 2/6/1991 0.021429 0.00025 0.01795 2 281 2/7/1991 0 0.00025 -0.00415 292 2/9/1991 0.006992 0.00025 0.00655 283 2/11/1991 0.013889 0.00025 0.02395 281 2/12/1991 -0.013699 0.00025 -0.00565 . > 285 2/13/1991 0.020833 0.00025 0.00915 286 2/14/1991 0.068027 0.00025 -0.01175 543 PM 287 /15/1991 -0.006364 0.00025 0.01225 Wednesday 258 -0.00641 0.00025 0.00155 4/22/2020 289 -0.006152 0.00025 -0.01035 assignmentdata 2/19/1991 2/20/1991 # - H + 100%