applications of statistical methods assignment.
n123
Assign4Data.mpx/project_metadata.json
{"Version":19.20201,"Worksheets":{"Items":[{"Id":"0f5a997e-3451-496e-8775-507c76208ea6","Name":"Location Analysis","Uri":"/sheets/0/sheet","Comments":"","Creator":"","Date":"","ExtraInformation":{"hidden_columns":[],"column_widths":{"default":8.0},"horizontal_scroll":1.0,"vertical_scroll":1.0,"cell_selection_start_row":1.0,"cell_selection_end_row":1.0,"cell_selection_start_column":1.0,"cell_selection_end_column":1.0,"selected_cell_row":0.0,"selected_cell_column":1.0}},{"Id":"c1ec750a-c29c-4689-a7ee-4508b58c0bfc","Name":"Investment Portfolio","Uri":"/sheets/1/sheet","Comments":"","Creator":"","Date":"","ExtraInformation":{"hidden_columns":[],"column_widths":{"default":8.0},"horizontal_scroll":1.0,"vertical_scroll":1.0,"cell_selection_start_row":1.0,"cell_selection_end_row":1.0,"cell_selection_start_column":1.0,"cell_selection_end_column":1.0,"selected_cell_row":0.0,"selected_cell_column":1.0}}],"ExtraInformation":{"current_worksheet":"c1ec750a-c29c-4689-a7ee-4508b58c0bfc","worksheet_ordering":["c1ec750a-c29c-4689-a7ee-4508b58c0bfc","0f5a997e-3451-496e-8775-507c76208ea6"]}},"Commands":{"Items":[],"ExtraInformation":{"layout":{"groups":[],"active":0.0}},"PendingUpdates":[],"Class_Version":[2]},"History":["WOPEN \"Z:\\Desktop\\Assign4Data.xlsx\";\nDATA;\nIGNOREBLANKROWS;\nEQUALCOLUMNS;\nSHEET 1;\nVNAMES 1;\nFIRST 2;\nSHEET 2;\nVNAMES 1;\nFIRST 2.","Save \"Z:\\Desktop\\Assign4Data.mpx\";\nProject.","Save \"Z:\\Desktop\\Assign4Data2.mpx\";\nProject."],"Creator":"","Date":"","Comments":"","Id":"7e706986-b232-4147-93fa-90d5d84b1c75","NextSheet":2,"ExtraInformation":{},"Models":{"Items":[{"Type":"ClassificationTree","Uri":"","NextTreeId":1,"Items":[],"Class_Version":[2]},{"Type":"RegressionTree","Uri":"","NextTreeId":1,"Items":[],"Class_Version":[2]},{"Type":"ClassificationTreeNet","Uri":"","NextTreeId":1,"Items":[],"Class_Version":[2]},{"Type":"RegressionTreeNet","Uri":"","NextTreeId":1,"Items":[],"Class_Version":[2]}]},"Reports":{"Items":[]},"Class_Version":[3]}
/sheets/0/sheet.json
{"Data":{"ClassId":1,"Type_DEP":1263685463,"IOtype_DEP":1,"Name":"","PrivateTitle":"Location Analysis","HTMLOptions":{"ClassId":0,"Title":""},"WorksheetViewData":{"ClassId":0,"PrintGrid":true,"PrintColNames":true,"PrintColLabels":true,"PrintRowLabels":true,"UseAllColumns":true,"DirectionIsHorizontal":true,"ActiveRow":1,"ActiveCol":1,"TopVisibleRow":1,"LeftmostVisibleCol":1,"StandardColumnWidthInt":8,"PrintJustification":2,"DataStyle":0,"LabelStyle":2,"DataPointSize":10,"LabelPointSize":10,"StandardColumnWidthDouble":8.0,"DataFaceName":"Arial","LabelFaceName":"Arial","MissingValue":"*"},"UseHiddenColumns":false,"Columns":[{"ClassId":434,"DefaultBody":false,"VarId":{"ClassId":440,"Variable":3,"Copy":false,"Attached":true,"VarId":1},"WorksheetVarBody":{"ClassId":437,"Name":"Location ID Number","Desc":"","Format":{"Key":1,"Value":{"ClassId":17,"AutoFormat":true,"MissingValueLabel":"*","PrevMissingValueLabel":"*","StrToStr":[],"DataToStr":[],"Numeric":2,"NumDecPlaces":0,"PlacesToLeft":4,"MinValue":0.0,"MaxValue":3799.0,"Subtype":0,"ShowFullPrecision":false,"Class_Version":[3,1]}},"VarData":{"ClassId":439,"VariableType":3,"Data":1,"VarDataBody":{"ClassId":0,"CellCt":100,"ColCt":1,"CharCt":0,"HasNumericData":true,"NumericData":[2801.0,2608.0,3191.0,3210.0,3701.0,2547.0,2670.0,2664.0,2492.0,2649.0,3066.0,2193.0,2793.0,3620.0,2538.0,3730.0,3120.0,2389.0,3053.0,3304.0,3770.0,3380.0,2795.0,2315.0,2682.0,2789.0,2847.0,2372.0,3349.0,3704.0,2872.0,2570.0,2956.0,3098.0,3256.0,2486.0,3466.0,2912.0,3200.0,3208.0,3799.0,3450.0,2403.0,2555.0,3056.0,2331.0,2806.0,2802.0,2501.0,2636.0,3016.0,3581.0,2395.0,2365.0,3152.0,3071.0,2698.0,3026.0,2785.0,2973.0,2785.0,2834.0,2146.0,3625.0,3328.0,3358.0,2230.0,2662.0,3736.0,3227.0,2718.0,3675.0,2960.0,3405.0,2793.0,2675.0,2874.0,3467.0,3593.0,2596.0,3341.0,3479.0,2656.0,2617.0,2114.0,3287.0,3531.0,3562.0,3648.0,3569.0,3038.0,2663.0,2971.0,3116.0,2546.0,2118.0,2117.0,3794.0,2910.0,3504.0],"HasTextData":false},"Locked":false,"Class_Version":[2]},"Ordering":{"ClassId":0,"DefinedSortOrder":0,"NumericOrder":[],"TextOrder":[]},"FormatType":3,"GeneralVarFmt":{"ClassId":0,"Hidden":false,"AutoWidening":true,"FormatSet":false,"DisplayedWidthDouble":17.428571428571428,"DisplayedWidthInt":17,"WidthSetIndividually":false},"Available":true,"Compressed":false,"HasChanged":false,"FormatDirty":false},"WorksheetVar":null,"Id":"622ebff4-35a6-41f7-8ad2-3a1892f67156","Class_Version":[1,2]},{"ClassId":434,"DefaultBody":false,"VarId":{"ClassId":440,"Variable":3,"Copy":false,"Attached":true,"VarId":2},"WorksheetVarBody":{"ClassId":437,"Name":"Operating Margin","Desc":"","Format":{"Key":1,"Value":{"ClassId":17,"AutoFormat":false,"MissingValueLabel":"*","PrevMissingValueLabel":"*","StrToStr":[],"DataToStr":[],"Numeric":0,"NumDecPlaces":1,"PlacesToLeft":0,"MinValue":0.0,"MaxValue":0.0,"Subtype":1,"ShowFullPrecision":false,"Class_Version":[3,1]}},"VarData":{"ClassId":439,"VariableType":3,"Data":1,"VarDataBody":{"ClassId":0,"CellCt":100,"ColCt":1,"CharCt":0,"HasNumericData":true,"NumericData":[39.3,49.5,49.0,45.1,41.9,43.5,40.3,42.8,57.3,52.1,25.1,54.4,47.3,57.4,38.4,56.5,35.2,39.3,47.3,44.2,54.4,51.5,46.2,49.8,41.1,51.1,52.2,49.9,39.8,43.5,45.4,58.5,46.0,81.5,41.0,46.0,48.8,53.5,54.1,34.3,50.2,43.3,40.8,49.0,52.0,51.2,52.7,35.7,40.0,60.1,48.2,36.8,55.4,33.8,51.2,42.9,36.1,47.5,33.2,54.2,32.4,54.1,49.0,46.3,41.6,43.2,54.4,42.5,45.0,33.5,35.9,38.1,44.0,71.2,37.8,43.7,40.2,55.5,44.9,38.8,52.6,53.0,58.0,54.2,60.5,47.6,36.9,34.5,30.8,49.0,45.5,51.4,49.6,31.9,53.4,48.8,39.2,43.4,41.0,49.6],"HasTextData":false},"Locked":false,"Class_Version":[2]},"Ordering":{"ClassId":0,"DefinedSortOrder":0,"NumericOrder":[],"TextOrder":[]},"FormatType":3,"GeneralVarFmt":{"ClassId":0,"Hidden":false,"AutoWidening":true,"FormatSet":false,"DisplayedWidthDouble":15.428571428571429,"DisplayedWidthInt":15,"WidthSetIndividually":false},"Available":true,"Compressed":false,"HasChanged":false,"FormatDirty":false},"WorksheetVar":null,"Id":"d44b23eb-ade4-4130-976e-c56d281d6b28","Class_Version":[1,2]},{"ClassId":434,"DefaultBody":false,"VarId":{"ClassId":440,"Variable":3,"Copy":false,"Attached":true,"VarId":3},"WorksheetVarBody":{"ClassId":437,"Name":"Number","Desc":"","Format":{"Key":1,"Value":{"ClassId":17,"AutoFormat":true,"MissingValueLabel":"*","PrevMissingValueLabel":"*","StrToStr":[],"DataToStr":[],"Numeric":2,"NumDecPlaces":0,"PlacesToLeft":4,"MinValue":0.0,"MaxValue":4214.0,"Subtype":0,"ShowFullPrecision":false,"Class_Version":[3,1]}},"VarData":{"ClassId":439,"VariableType":3,"Data":1,"VarDataBody":{"ClassId":0,"CellCt":100,"ColCt":1,"CharCt":0,"HasNumericData":true,"NumericData":[3591.0,2726.0,2890.0,2172.0,3517.0,2910.0,2848.0,3003.0,2601.0,3140.0,1613.0,3234.0,2761.0,2687.0,3264.0,2045.0,3251.0,3159.0,2642.0,3471.0,2756.0,3069.0,2244.0,2859.0,3098.0,3227.0,2879.0,3255.0,3823.0,3198.0,2443.0,2210.0,2655.0,4214.0,3480.0,2341.0,2935.0,3285.0,2862.0,3548.0,3021.0,3383.0,2676.0,2826.0,3354.0,3082.0,3378.0,3591.0,3397.0,2619.0,2429.0,3006.0,2790.0,2810.0,2775.0,3838.0,2962.0,3080.0,2629.0,2484.0,3124.0,2432.0,1998.0,2554.0,2776.0,2724.0,3241.0,2403.0,3697.0,3657.0,2786.0,3568.0,2813.0,3567.0,2980.0,2915.0,3670.0,3203.0,3003.0,3330.0,3013.0,2844.0,2382.0,3018.0,2932.0,2751.0,2923.0,2730.0,3622.0,3759.0,2691.0,2640.0,3359.0,3422.0,2772.0,2825.0,2996.0,3597.0,2846.0,2922.0],"HasTextData":false},"Locked":false,"Class_Version":[2]},"Ordering":{"ClassId":0,"DefinedSortOrder":0,"NumericOrder":[],"TextOrder":[]},"FormatType":3,"GeneralVarFmt":{"ClassId":0,"Hidden":false,"AutoWidening":true,"FormatSet":false,"DisplayedWidthDouble":0.0,"DisplayedWidthInt":0,"WidthSetIndividually":false},"Available":true,"Compressed":false,"HasChanged":false,"FormatDirty":false},"WorksheetVar":null,"Id":"4804bf08-1fb2-4a02-94bc-74b1171f73bf","Class_Version":[1,2]},{"ClassId":434,"DefaultBody":false,"VarId":{"ClassId":440,"Variable":3,"Copy":false,"Attached":true,"VarId":4},"WorksheetVarBody":{"ClassId":437,"Name":"Nearest","Desc":"","Format":{"Key":1,"Value":{"ClassId":17,"AutoFormat":false,"MissingValueLabel":"*","PrevMissingValueLabel":"*","StrToStr":[],"DataToStr":[],"Numeric":0,"NumDecPlaces":1,"PlacesToLeft":0,"MinValue":0.0,"MaxValue":0.0,"Subtype":1,"ShowFullPrecision":false,"Class_Version":[3,1]}},"VarData":{"ClassId":439,"VariableType":3,"Data":1,"VarDataBody":{"ClassId":0,"CellCt":100,"ColCt":1,"CharCt":0,"HasNumericData":true,"NumericData":[2.0,1.2,2.4,1.4,2.9,1.4,2.5,2.2,3.1,2.2,1.7,3.2,3.4,0.9,2.7,1.5,1.7,2.7,1.8,2.2,3.2,3.3,3.6,1.7,2.3,1.9,2.1,2.2,3.6,1.8,0.1,2.7,1.1,2.4,1.9,2.3,3.9,2.0,2.9,2.5,1.7,2.2,3.3,4.2,2.0,1.5,3.3,1.4,1.6,2.9,2.3,2.5,1.6,2.8,2.5,2.4,0.9,1.9,1.4,2.8,1.6,2.9,3.6,2.1,2.1,1.2,2.2,1.0,2.1,1.5,1.9,2.3,3.8,2.5,3.2,1.6,2.8,4.2,0.9,2.7,3.7,3.5,3.2,3.1,1.8,3.0,1.2,0.3,2.3,2.9,3.2,3.8,1.6,3.3,0.8,1.1,1.3,3.9,3.1,1.9],"HasTextData":false},"Locked":false,"Class_Version":[2]},"Ordering":{"ClassId":0,"DefinedSortOrder":0,"NumericOrder":[],"TextOrder":[]},"FormatType":3,"GeneralVarFmt":{"ClassId":0,"Hidden":false,"AutoWidening":true,"FormatSet":false,"DisplayedWidthDouble":0.0,"DisplayedWidthInt":0,"WidthSetIndividually":false},"Available":true,"Compressed":false,"HasChanged":false,"FormatDirty":false},"WorksheetVar":null,"Id":"17684841-a85b-4c88-a659-a325bdd5cf8f","Class_Version":[1,2]},{"ClassId":434,"DefaultBody":false,"VarId":{"ClassId":440,"Variable":3,"Copy":false,"Attached":true,"VarId":5},"WorksheetVarBody":{"ClassId":437,"Name":"Enrollment","Desc":"","Format":{"Key":1,"Value":{"ClassId":17,"AutoFormat":false,"MissingValueLabel":"*","PrevMissingValueLabel":"*","StrToStr":[],"DataToStr":[],"Numeric":0,"NumDecPlaces":1,"PlacesToLeft":0,"MinValue":0.0,"MaxValue":0.0,"Subtype":1,"ShowFullPrecision":false,"Class_Version":[3,1]}},"VarData":{"ClassId":439,"VariableType":3,"Data":1,"VarDataBody":{"ClassId":0,"CellCt":100,"ColCt":1,"CharCt":0,"HasNumericData":true,"NumericData":[18.5,19.0,20.0,7.0,6.0,12.5,19.0,19.5,18.5,23.5,21.5,19.5,16.0,15.5,22.5,15.0,13.0,11.0,9.0,12.0,14.5,20.5,15.5,14.5,11.5,11.0,19.5,22.5,17.0,17.0,10.5,17.5,22.0,16.0,18.0,23.0,20.0,23.5,16.5,13.5,8.5,11.5,25.0,17.0,26.5,22.0,10.0,9.5,19.5,12.0,20.0,15.5,12.0,17.5,15.0,10.0,12.5,13.5,20.0,16.0,17.0,17.5,19.0,10.0,16.0,14.5,21.5,19.0,20.5,18.0,15.5,16.5,15.0,13.5,12.0,13.5,17.5,8.0,15.5,13.5,20.0,13.5,12.0,20.0,19.5,10.5,14.0,17.0,15.0,19.0,13.5,19.5,10.5,15.5,14.5,13.0,15.5,15.5,20.5,19.5],"HasTextData":false},"Locked":false,"Class_Version":[2]},"Ordering":{"ClassId":0,"DefinedSortOrder":0,"NumericOrder":[],"TextOrder":[]},"FormatType":3,"GeneralVarFmt":{"ClassId":0,"Hidden":false,"AutoWidening":true,"FormatSet":false,"DisplayedWidthDouble":9.428571428571429,"DisplayedWidthInt":9,"WidthSetIndividually":false},"Available":true,"Compressed":false,"HasChanged":false,"FormatDirty":false},"WorksheetVar":null,"Id":"a8d251cf-ad08-4c9c-94b9-c06bb7b8d236","Class_Version":[1,2]},{"ClassId":434,"DefaultBody":false,"VarId":{"ClassId":440,"Variable":3,"Copy":false,"Attached":true,"VarId":6},"WorksheetVarBody":{"ClassId":437,"Name":"Income","Desc":"","Format":{"Key":1,"Value":{"ClassId":17,"AutoFormat":true,"MissingValueLabel":"*","PrevMissingValueLabel":"*","StrToStr":[],"DataToStr":[],"Numeric":2,"NumDecPlaces":0,"PlacesToLeft":2,"MinValue":0.0,"MaxValue":46.0,"Subtype":0,"ShowFullPrecision":false,"Class_Version":[3,1]}},"VarData":{"ClassId":439,"VariableType":3,"Data":1,"VarDataBody":{"ClassId":0,"CellCt":100,"ColCt":1,"CharCt":0,"HasNumericData":true,"NumericData":[29.0,36.0,35.0,35.0,38.0,35.0,30.0,39.0,39.0,34.0,29.0,39.0,39.0,42.0,29.0,38.0,35.0,34.0,30.0,39.0,39.0,37.0,36.0,39.0,34.0,37.0,36.0,36.0,38.0,36.0,36.0,35.0,34.0,34.0,31.0,29.0,35.0,42.0,41.0,31.0,41.0,33.0,41.0,34.0,37.0,40.0,34.0,43.0,32.0,31.0,33.0,37.0,37.0,35.0,39.0,40.0,41.0,43.0,35.0,33.0,29.0,35.0,41.0,32.0,31.0,42.0,44.0,32.0,40.0,28.0,37.0,37.0,33.0,32.0,32.0,36.0,37.0,37.0,37.0,41.0,41.0,30.0,39.0,39.0,39.0,36.0,40.0,33.0,34.0,33.0,46.0,37.0,44.0,38.0,45.0,40.0,38.0,35.0,31.0,32.0],"HasTextData":false},"Locked":false,"Class_Version":[2]},"Ordering":{"ClassId":0,"DefinedSortOrder":0,"NumericOrder":[],"TextOrder":[]},"FormatType":3,"GeneralVarFmt":{"ClassId":0,"Hidden":false,"AutoWidening":true,"FormatSet":false,"DisplayedWidthDouble":0.0,"DisplayedWidthInt":0,"WidthSetIndividually":false},"Available":true,"Compressed":false,"HasChanged":false,"FormatDirty":false},"WorksheetVar":null,"Id":"b850364c-4521-46ae-970c-f13169b9610d","Class_Version":[1,2]},{"ClassId":434,"DefaultBody":false,"VarId":{"ClassId":440,"Variable":3,"Copy":false,"Attached":true,"VarId":7},"WorksheetVarBody":{"ClassId":437,"Name":"Distance","Desc":"","Format":{"Key":1,"Value":{"ClassId":17,"AutoFormat":false,"MissingValueLabel":"*","PrevMissingValueLabel":"*","StrToStr":[],"DataToStr":[],"Numeric":0,"NumDecPlaces":1,"PlacesToLeft":0,"MinValue":0.0,"MaxValue":0.0,"Subtype":1,"ShowFullPrecision":false,"Class_Version":[3,1]}},"VarData":{"ClassId":439,"VariableType":3,"Data":1,"VarDataBody":{"ClassId":0,"CellCt":100,"ColCt":1,"CharCt":0,"HasNumericData":true,"NumericData":[7.6,9.3,2.6,9.2,9.1,1.8,8.4,12.0,11.0,3.7,4.1,8.3,6.6,6.9,10.4,4.3,4.3,0.2,4.8,5.4,7.9,7.7,5.9,3.0,7.7,6.0,2.9,8.7,4.8,4.6,7.5,2.7,8.1,5.6,11.0,7.4,6.1,2.9,11.8,8.3,5.5,9.5,5.1,1.2,7.2,11.2,7.6,5.0,3.1,6.8,7.6,4.2,9.1,14.4,5.6,2.9,8.6,8.1,7.2,0.6,7.3,10.3,4.9,9.9,7.3,0.3,5.1,8.2,9.0,3.5,8.5,3.7,11.8,9.1,6.6,5.3,9.9,2.7,10.2,4.0,14.1,10.8,1.3,8.2,6.1,9.1,7.6,4.3,7.6,10.8,5.7,7.6,2.6,12.1,11.3,9.0,8.5,13.2,8.8,4.4],"HasTextData":false},"Locked":false,"Class_Version":[2]},"Ordering":{"ClassId":0,"DefinedSortOrder":0,"NumericOrder":[],"TextOrder":[]},"FormatType":3,"GeneralVarFmt":{"ClassId":0,"Hidden":false,"AutoWidening":true,"FormatSet":false,"DisplayedWidthDouble":0.0,"DisplayedWidthInt":0,"WidthSetIndividually":false},"Available":true,"Compressed":false,"HasChanged":false,"FormatDirty":false},"WorksheetVar":null,"Id":"14d13143-384d-4130-a34f-8fb3cc498cca","Class_Version":[1,2]},{"ClassId":434,"DefaultBody":false,"VarId":{"ClassId":440,"Variable":3,"Copy":false,"Attached":true,"VarId":8},"WorksheetVarBody":{"ClassId":437,"Name":"Quality","Desc":"","Format":{"Key":1,"Value":{"ClassId":17,"AutoFormat":false,"MissingValueLabel":"*","PrevMissingValueLabel":"*","StrToStr":[],"DataToStr":[],"Numeric":0,"NumDecPlaces":0,"PlacesToLeft":0,"MinValue":0.0,"MaxValue":0.0,"Subtype":1,"ShowFullPrecision":false,"Class_Version":[3,1]}},"VarData":{"ClassId":439,"VariableType":3,"Data":1,"VarDataBody":{"ClassId":0,"CellCt":100,"ColCt":1,"CharCt":0,"HasNumericData":true,"NumericData":[2.0,3.0,3.0,3.0,2.0,2.0,2.0,2.0,4.0,3.0,4.0,4.0,3.0,4.0,2.0,4.0,1.0,2.0,3.0,3.0,4.0,3.0,3.0,3.0,2.0,3.0,3.0,3.0,2.0,2.0,3.0,4.0,3.0,1.0,2.0,3.0,3.0,3.0,3.0,1.0,3.0,2.0,2.0,3.0,3.0,3.0,3.0,1.0,2.0,4.0,3.0,2.0,4.0,1.0,3.0,2.0,1.0,3.0,1.0,3.0,1.0,3.0,3.0,3.0,2.0,2.0,4.0,2.0,3.0,1.0,1.0,2.0,2.0,1.0,2.0,2.0,2.0,4.0,3.0,2.0,3.0,3.0,4.0,3.0,4.0,3.0,2.0,1.0,1.0,3.0,3.0,3.0,3.0,1.0,3.0,3.0,2.0,2.0,2.0,3.0],"HasTextData":false},"Locked":false,"Class_Version":[2]},"Ordering":{"ClassId":0,"DefinedSortOrder":0,"NumericOrder":[],"TextOrder":[]},"FormatType":3,"GeneralVarFmt":{"ClassId":0,"Hidden":false,"AutoWidening":true,"FormatSet":false,"DisplayedWidthDouble":0.0,"DisplayedWidthInt":0,"WidthSetIndividually":false},"Available":true,"Compressed":false,"HasChanged":false,"FormatDirty":false},"WorksheetVar":null,"Id":"eea2d726-9733-49db-b424-faa1c6884fda","Class_Version":[1,2]},{"ClassId":434,"DefaultBody":false,"VarId":{"ClassId":440,"Variable":3,"Copy":false,"Attached":true,"VarId":9},"WorksheetVarBody":{"ClassId":437,"Name":"High Speed Internet","Desc":"","Format":{"Key":1,"Value":{"ClassId":17,"AutoFormat":true,"MissingValueLabel":"*","PrevMissingValueLabel":"*","StrToStr":[],"DataToStr":[],"Numeric":2,"NumDecPlaces":0,"PlacesToLeft":1,"MinValue":0.0,"MaxValue":2.0,"Subtype":0,"ShowFullPrecision":false,"Class_Version":[3,1]}},"VarData":{"ClassId":439,"VariableType":3,"Data":1,"VarDataBody":{"ClassId":0,"CellCt":100,"ColCt":1,"CharCt":0,"HasNumericData":true,"NumericData":[1.0,2.0,1.0,2.0,2.0,2.0,1.0,1.0,2.0,2.0,2.0,2.0,1.0,2.0,1.0,2.0,1.0,1.0,1.0,2.0,2.0,2.0,1.0,2.0,1.0,2.0,2.0,2.0,1.0,2.0,2.0,2.0,1.0,1.0,1.0,2.0,1.0,2.0,2.0,1.0,1.0,2.0,1.0,2.0,2.0,2.0,2.0,1.0,1.0,2.0,1.0,1.0,2.0,1.0,1.0,1.0,1.0,1.0,1.0,2.0,1.0,2.0,2.0,1.0,1.0,2.0,2.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,1.0,2.0,1.0,2.0,2.0,1.0,2.0,2.0,2.0,2.0,2.0,2.0,1.0,1.0,1.0,2.0,2.0,2.0,2.0,1.0,2.0,1.0,1.0,1.0,1.0,1.0],"HasTextData":false},"Locked":false,"Class_Version":[2]},"Ordering":{"ClassId":0,"DefinedSortOrder":0,"NumericOrder":[],"TextOrder":[]},"FormatType":3,"GeneralVarFmt":{"ClassId":0,"Hidden":false,"AutoWidening":true,"FormatSet":false,"DisplayedWidthDouble":17.571428571428574,"DisplayedWidthInt":17,"WidthSetIndividually":false},"Available":true,"Compressed":false,"HasChanged":false,"FormatDirty":false},"WorksheetVar":null,"Id":"9f2e3666-03ab-41ec-9a85-d4ec33fac048","Class_Version":[1,2]},{"ClassId":434,"DefaultBody":false,"VarId":{"ClassId":440,"Variable":3,"Copy":false,"Attached":true,"VarId":10},"WorksheetVarBody":{"ClassId":437,"Name":"Gym","Desc":"","Format":{"Key":1,"Value":{"ClassId":17,"AutoFormat":true,"MissingValueLabel":"*","PrevMissingValueLabel":"*","StrToStr":[],"DataToStr":[],"Numeric":2,"NumDecPlaces":0,"PlacesToLeft":1,"MinValue":0.0,"MaxValue":2.0,"Subtype":0,"ShowFullPrecision":false,"Class_Version":[3,1]}},"VarData":{"ClassId":439,"VariableType":3,"Data":1,"VarDataBody":{"ClassId":0,"CellCt":100,"ColCt":1,"CharCt":0,"HasNumericData":true,"NumericData":[1.0,2.0,2.0,2.0,1.0,1.0,2.0,1.0,2.0,2.0,2.0,2.0,2.0,2.0,1.0,2.0,1.0,1.0,2.0,1.0,1.0,2.0,1.0,2.0,2.0,2.0,2.0,2.0,2.0,1.0,1.0,2.0,1.0,1.0,2.0,2.0,2.0,2.0,1.0,2.0,2.0,1.0,1.0,2.0,2.0,2.0,2.0,1.0,1.0,2.0,2.0,1.0,1.0,1.0,2.0,1.0,1.0,2.0,1.0,1.0,1.0,1.0,2.0,1.0,2.0,1.0,2.0,1.0,1.0,1.0,1.0,1.0,1.0,2.0,1.0,1.0,1.0,2.0,1.0,1.0,1.0,1.0,2.0,1.0,2.0,2.0,1.0,1.0,1.0,2.0,2.0,2.0,2.0,1.0,2.0,2.0,1.0,1.0,2.0,2.0],"HasTextData":false},"Locked":false,"Class_Version":[2]},"Ordering":{"ClassId":0,"DefinedSortOrder":0,"NumericOrder":[],"TextOrder":[]},"FormatType":3,"GeneralVarFmt":{"ClassId":0,"Hidden":false,"AutoWidening":true,"FormatSet":false,"DisplayedWidthDouble":0.0,"DisplayedWidthInt":0,"WidthSetIndividually":false},"Available":true,"Compressed":false,"HasChanged":false,"FormatDirty":false},"WorksheetVar":null,"Id":"8368c7a1-cad9-4bf1-be93-9a0f4fe3344d","Class_Version":[1,2]},{"ClassId":434,"DefaultBody":false,"VarId":{"ClassId":440,"Variable":3,"Copy":false,"Attached":true,"VarId":11},"WorksheetVarBody":{"ClassId":437,"Name":"Operating Margin New","Desc":"","Format":{"Key":1,"Value":{"ClassId":17,"AutoFormat":false,"MissingValueLabel":"*","PrevMissingValueLabel":"*","StrToStr":[],"DataToStr":[],"Numeric":0,"NumDecPlaces":1,"PlacesToLeft":0,"MinValue":0.0,"MaxValue":0.0,"Subtype":1,"ShowFullPrecision":false,"Class_Version":[3,1]}},"VarData":{"ClassId":439,"VariableType":3,"Data":1,"VarDataBody":{"ClassId":0,"CellCt":100,"ColCt":1,"CharCt":0,"HasNumericData":true,"NumericData":[39.3,49.5,49.0,45.1,41.9,43.5,40.3,42.8,57.3,52.1,1.23456e30,54.4,47.3,57.4,38.4,56.5,35.2,39.3,47.3,44.2,54.4,51.5,46.2,49.8,41.1,51.1,52.2,49.9,39.8,43.5,45.4,58.5,46.0,1.23456e30,41.0,46.0,48.8,53.5,54.1,34.3,50.2,43.3,40.8,49.0,52.0,51.2,52.7,35.7,40.0,60.1,48.2,36.8,55.4,33.8,51.2,42.9,36.1,47.5,33.2,54.2,32.4,54.1,49.0,46.3,41.6,43.2,54.4,42.5,45.0,33.5,35.9,38.1,44.0,1.23456e30,37.8,43.7,40.2,55.5,44.9,38.8,52.6,53.0,58.0,54.2,60.5,47.6,36.9,34.5,30.8,49.0,45.5,51.4,49.6,31.9,53.4,48.8,39.2,43.4,41.0,49.6],"HasTextData":false},"Locked":false,"Class_Version":[2]},"Ordering":{"ClassId":0,"DefinedSortOrder":0,"NumericOrder":[],"TextOrder":[]},"FormatType":3,"GeneralVarFmt":{"ClassId":0,"Hidden":false,"AutoWidening":true,"FormatSet":false,"DisplayedWidthDouble":19.857142857142859,"DisplayedWidthInt":19,"WidthSetIndividually":false},"Available":true,"Compressed":false,"HasChanged":false,"FormatDirty":false},"WorksheetVar":null,"Id":"ac84f88d-a539-444b-a556-691a89822f8c","Class_Version":[1,2]}],"Constants":[],"Matrices":[],"HasDOE":false,"DDE":[],"Unknown_DEP":[],"FormulaManager":{"ClassId":0,"UpdateAutomatically":true,"RecalcNeeded":false,"StatusUpdateNeeded":false,"SetNodes":[],"Class_Version":[1,1]},"RegressionModel":[],"ResponseSurfaceModel":[],"FactorialModel":[],"BinaryLogisticModel":[],"PoissonRegressionModel":[],"GeneralLinearModel":[],"StabilityStudyModel":[],"ConditionalFormatManager":{"ClassId":0,"Formats":[],"Class_Version":[1,1]},"CellPropertiesManager":{"ClassId":0,"CellStyles":[],"UserDefinedCellStyle":[],"CellComments":[],"Class_Version":[1,1]},"DefinitiveScreeningModel":[],"REMLModel":[],"WorksheetId_DEP":"0f5a997e-3451-496e-8775-507c76208ea6","Class_Version":[1,7]},"Word_DEP":{},"MaxRows_DEP":100,"MaxColumns_DEP":11,"MaxConstants_DEP":0,"MaxMatrices_DEP":0,"CreationDate":0,"LastSavedDate":0,"Version":0.0,"SaveAsVersion":19.0,"Creator":"","Date":"","Comment":"","OSVersion_DEP":0,"CodePage_DEP":0,"CreatedDate":44281.71776614583,"SavedDate":44281.71943020833,"Class_Version":[2]}
/sheets/1/sheet.json
{"Data":{"ClassId":1,"Type_DEP":1263685463,"IOtype_DEP":1,"Name":"","PrivateTitle":"Investment Portfolio ***","HTMLOptions":{"ClassId":0,"Title":""},"WorksheetViewData":{"ClassId":0,"PrintGrid":true,"PrintColNames":true,"PrintColLabels":true,"PrintRowLabels":true,"UseAllColumns":true,"DirectionIsHorizontal":true,"ActiveRow":1,"ActiveCol":1,"TopVisibleRow":1,"LeftmostVisibleCol":1,"StandardColumnWidthInt":8,"PrintJustification":2,"DataStyle":0,"LabelStyle":2,"DataPointSize":10,"LabelPointSize":10,"StandardColumnWidthDouble":8.0,"DataFaceName":"Arial","LabelFaceName":"Arial","MissingValue":"*"},"UseHiddenColumns":false,"Columns":[{"ClassId":434,"DefaultBody":false,"VarId":{"ClassId":440,"Variable":3,"Copy":false,"Attached":true,"VarId":1},"WorksheetVarBody":{"ClassId":437,"Name":"Company A","Desc":"","Format":{"Key":1,"Value":{"ClassId":17,"AutoFormat":false,"MissingValueLabel":"*","PrevMissingValueLabel":"*","StrToStr":[],"DataToStr":[],"Numeric":0,"NumDecPlaces":2,"PlacesToLeft":0,"MinValue":0.0,"MaxValue":0.0,"Subtype":1,"ShowFullPrecision":false,"Class_Version":[3,1]}},"VarData":{"ClassId":439,"VariableType":3,"Data":1,"VarDataBody":{"ClassId":0,"CellCt":42,"ColCt":1,"CharCt":0,"HasNumericData":true,"NumericData":[1.309,-0.264,0.876,0.484,-0.492,0.372,-0.21600000000000003,1.342,0.209,0.924,0.756,-0.528,-0.72,0.05500000000000001,0.20400000000000002,0.40800000000000005,0.264,1.464,0.528,1.276,0.121,-0.516,-0.7260000000000001,1.056,1.331,-0.176,2.035,1.573,-0.504,0.9129999999999999,-0.253,0.616,-2.04,0.462,1.6940000000000002,0.11000000000000002,-0.552,1.128,0.9120000000000001,-1.188,-1.33,0.89],"HasTextData":false},"Locked":false,"Class_Version":[2]},"Ordering":{"ClassId":0,"DefinedSortOrder":0,"NumericOrder":[],"TextOrder":[]},"FormatType":3,"GeneralVarFmt":{"ClassId":0,"Hidden":false,"AutoWidening":true,"FormatSet":false,"DisplayedWidthDouble":10.142857142857143,"DisplayedWidthInt":10,"WidthSetIndividually":false},"Available":true,"Compressed":false,"HasChanged":false,"FormatDirty":false},"WorksheetVar":null,"Id":"3a179d45-3143-423d-83ee-78ed15d3bd26","Class_Version":[1,2]},{"ClassId":434,"DefaultBody":false,"VarId":{"ClassId":440,"Variable":3,"Copy":false,"Attached":true,"VarId":2},"WorksheetVarBody":{"ClassId":437,"Name":"Company B","Desc":"","Format":{"Key":1,"Value":{"ClassId":17,"AutoFormat":false,"MissingValueLabel":"*","PrevMissingValueLabel":"*","StrToStr":[],"DataToStr":[],"Numeric":0,"NumDecPlaces":2,"PlacesToLeft":0,"MinValue":0.0,"MaxValue":0.0,"Subtype":1,"ShowFullPrecision":false,"Class_Version":[3,1]}},"VarData":{"ClassId":439,"VariableType":3,"Data":1,"VarDataBody":{"ClassId":0,"CellCt":42,"ColCt":1,"CharCt":0,"HasNumericData":true,"NumericData":[0.376,1.269,0.5599999999999999,0.6209999999999999,-0.5519999999999999,-1.2419999999999998,-1.8719999999999999,1.2959999999999999,-0.192,0.42299999999999995,-1.0619999999999999,-1.071,0.576,0.6479999999999999,0.76,0.8459999999999999,0.744,0.8280000000000001,0.8280000000000001,0.36,0.184,-1.08,-0.9119999999999999,1.8719999999999999,2.853,-0.528,1.791,2.727,-0.756,1.332,-0.495,1.9280000000000002,-0.099,-0.9450000000000001,0.4,0.176,-2.5919999999999998,1.176,-0.7290000000000001,-1.7099999999999998,-3.11,0.77],"HasTextData":false},"Locked":false,"Class_Version":[2]},"Ordering":{"ClassId":0,"DefinedSortOrder":0,"NumericOrder":[],"TextOrder":[]},"FormatType":3,"GeneralVarFmt":{"ClassId":0,"Hidden":false,"AutoWidening":true,"FormatSet":false,"DisplayedWidthDouble":10.0,"DisplayedWidthInt":10,"WidthSetIndividually":false},"Available":true,"Compressed":false,"HasChanged":false,"FormatDirty":false},"WorksheetVar":null,"Id":"f6aca886-1fe5-4351-9b28-4499b2a89a63","Class_Version":[1,2]}],"Constants":[],"Matrices":[],"HasDOE":false,"DDE":[],"Unknown_DEP":[],"FormulaManager":{"ClassId":0,"UpdateAutomatically":true,"RecalcNeeded":false,"StatusUpdateNeeded":false,"SetNodes":[],"Class_Version":[1,1]},"RegressionModel":[],"ResponseSurfaceModel":[],"FactorialModel":[],"BinaryLogisticModel":[],"PoissonRegressionModel":[],"GeneralLinearModel":[],"StabilityStudyModel":[],"ConditionalFormatManager":{"ClassId":0,"Formats":[],"Class_Version":[1,1]},"CellPropertiesManager":{"ClassId":0,"CellStyles":[],"UserDefinedCellStyle":[],"CellComments":[],"Class_Version":[1,1]},"DefinitiveScreeningModel":[],"REMLModel":[],"WorksheetId_DEP":"c1ec750a-c29c-4689-a7ee-4508b58c0bfc","Class_Version":[1,7]},"Word_DEP":{},"MaxRows_DEP":42,"MaxColumns_DEP":2,"MaxConstants_DEP":0,"MaxMatrices_DEP":0,"CreationDate":0,"LastSavedDate":0,"Version":0.0,"SaveAsVersion":19.0,"Creator":"","Date":"","Comment":"","OSVersion_DEP":0,"CodePage_DEP":0,"CreatedDate":44281.71867189815,"SavedDate":44281.719430219906,"Class_Version":[2]}
