A First Look At FSBstats
FSBstats:A First Look
Table of ContentsPageWhat is FSBstats? . 1FSBstats Capabilities, Limits, and Requirements. 1How is FSBstats Installed? . 1Troubleshooting. 4What Does FSBstats Look Like? . 5The Name Your Data Command Group on the RibbonOrganize Your Data . 6Data with Labels and a Column-Wise Orientation . 4Data with Labels and a Row-Wise Orientation . 7The Data Analysis Command Group on the RibbonThe Data Analysis Button. 8Turn On/Off worksheet Headers . 9Regression and Forecasting Command Group on the RibbonThe Regression Button . 10Choose Regression Variables . 10Run a Regression Analysis . 12View the Regression Results . 12The “Model Summaries” Worksheet . 15Run another Regression Analysis . 16The Forecasting Button . 16Forecasting Troubleshooting NotesNeglect to Enter All Values . 17Attempt to Forecast from a Previous Forecast Values . 17Adding New Forecasts . 18AppendicesTurn On/Off Headers & Gridlines - Another Method . 19Install and Un-install FSBstats . 20Troubleshooting FSBstats . 2210.13.2011
What is FSBstats?FSBstats is an Excel 2010 add-in that provides custom options for regression analysisand forecasting. The FSBstats software was designed by Fuqua’s Decision Sciencesfaculty to supplement the regression and forecasting capabilities that come with Excel2010. Because these custom options are packaged as an Excel add-in, you can continue touse the familiar Excel interface for data analysis.FSBstats Capabilities, Limits, and RequirementsFSBstats can handle any number of observations. For data analysis it can handle up to 50variables. For regression analysis it can handle up to 30 variables.Expect the software to run more slowly for large data sets ( 5,000 rows of data). Closingany other unnecessary programs while running Excel with the FSBstats add-in mayimprove performance.FSBstats is written for Excel 2010 running on a computer with the Windows operatingsystem. Your copy of Excel must have a printer defined even if one is not available.How is FSBstats Installed?FSBstats is an Excel add-in1 that uses Excel 2010 as its host application. The mostconvenient way to install the software is to put a copy of the FSBstats.xlsm file in afolder on your computer’s hard drive and then to open that file in Excel.When you open the FSBstats.xlsm in Excel you may or may not first see a MicrosoftSecurity Notice like the one below:If you see this dialog,click the “EnableMacros” button toproceed.An Excel Add-In is an extension of the Excel software. When installed and active, the add-in’soptions are available through Excel’s ribbon. Solver is an example of an add-in that’s part ofMicrosoft Excel (though often not installed). FSBstats is an example of a third-party Excel add-in.11
Then the “FSBstats.xlam” installation dialog displays. It looks like the one picturedbelow. The dialog allows one of three choices: “Yes”, “No”, or “Cancel”.The simplest choice is “Yes”. When you choose “Yes” Excel displays an informationdialog asking if it should copy the FSBstats file to your Excel Addins folder. Click “Yes”.FSBstats auto installs itself as an Excel add-in. Notice that a new “FSBstats” tab appearson your Excel ribbon.2
Check your Excel “Add-Ins” to see that FSBstats has been included. To do this:1. Click the “File” tab on the ribbon.2. Choose “Options” from the navigation area at left. The “Excel Options” dialogopens.3. Choose “Add-Ins” from the navigation area in the “Excel Options” dialog. Thepane that displays looks something like the one below (depending on how yourcopy of Excel is configured). What you’re looking for on this pane is the“Manage:” item at the bottom of the dialog. Click the drop-down to the right of“Manage:” and choose “Excel Add-ins”.4. Then click the “Go” button.Excel displays its “Add-Ins” dialog (see the next page).3
The Add-Ins dialog should have a Regression Analysis entry and if yourinstallation of FSBstats was successful that entry will have a check markto the left of it. Click “OK”.See the Appendix for more information on installing and un-installing the FSBstatssoftware.TroubleshootingIf you do NOT see a Regression Analysis entry in your “Add-Ins” dialog, click the“Browse ” button and navigate to the FSBstats.xlam file on your computer.Select that file and click the “OK”button.You should then see the “Add-Ins” dialog with the Regression Analysis entry. Clickthat entry’s check box if necessary to turn it on; then, click “OK”.4
If the installation worked youshould now see an FSBstatstab on your Excel ribbon.What Does FSBstats Look Like?With the FSBstats add-in installed you’ll a new “FSBstats” tab appears at the right ofyour Excel 2010 ribbon. When you click that tab three groupings of commands appearon the ribbon as the FSBstats toolbar:Name Your DataAnalyze Your DataRegression and ForecastingThe buttons in these three groups look and operate like standard Excel 2010 commandbuttons.5
The Name Your Data Command Group on the RibbonThe data you plan to analyze with FSBstats must be stored in named ranges. The rangenames are used in FSBstat’s dialogs and as the variable names in the output.Organize Your DataIf you have the luxury of organizing the data to analyzeit’s best to organize your data on the worksheet in the formof a table in which the names you want to use for yourvariables are the table’s row or column labels. You canthen use the “Create from Selection” button in the “NameYour Data” group to quickly name each of your variableranges.The data set used in the examples shown in this document is the fictitious “Mrs.Smythe’s Gourmet Frozen Fruit Pie Regional Market Demand Data, 2003-1 to 2004-4”.Note: Names in Alphabetical OrderIn your FSBstats output the variables will be listed in alphabetical order. If you’rechoosing your own range names for your data you may want to take this into account.For example, if your labels are month names (January, February, March, ) you mightwant to assign range names that will display the month data in month order (01January,02February, 03March, ).Data with Labels and a Column-Wise OrientationData organized in columns might look like the sample below. Each column of values hasa label above it: “Unit Sales”, “Price”, “Ads”, etc.The “Create from Selection” button generates names from selected cells. All the columnsof data in the sample shown above can be assigned names in a single operation. Eachcolumn of data takes the name of the label above it. The label cell is not included in thenamed range.6
Data with Labels and a Row-Wise OrientationYou might find that your data is arranged in a row-wise orientation instead of a columnwise orientation. For example, the same data shown above but organized in rowsinstead of columns looks like the sample below. Here, each row of values has a label toits left: “Unit Sales”, “Price”, “Ads”, etc.To range name this data:1) Select all the rows of data and the labelsto their left (click any cell with a datavalue or label, depress the CONTROLand SHIFT keys and tap the 8* keys).2) Click the “Create from Selection” buttonin the “Name Your Data” group.3) If “Left column” isn’t already specifiedas the source for range names, select it.4) Click the OK button to create the names.Again, Excel makes the correct assumption; here, that you’d like to use the labels in theleft-most column of the selection to name the rows of data. Then:5) Click any cell to remove the selection.6) Check to make sure Excel has properly named your data by entering a rangename in the Name Box of the Formula Bar and making sure it refers to the rightdata.For example, enter the range name “Ads” in the Formula Bar Name Box. Excelhighlights the data range assigned the name “Ads”. Here, that range is data in a row.Again note that the text label in Cell C8 is not part of the named range.7
The Data Analysis Command Group on the RibbonWith your data ranges named, you can begin working with the data analysis features ofthe FSBstats software.The Data Analysis ButtonFind the “Analyze Your Data” group on the FSBstats tab. Click the “Data Analysis”button to open the “Select Variables for Data Analysis” dialog. This dialog displays allthe range names in your worksheet along with the number of values in each range. Inthe illustration below each variable has 48 values. This is important information sincemany analyses depend for completeness on having the same number of values in eachvariable. Below, the Select All Variables button has been selected. The check boxes to theleft of all the range names in the list of named data ranges are automatically selected.FSBstats provides a default“Analysis Name” (in theillustration at left, “DataAnalysis 1”). You canreplace this name with yourown analysis name if youlike. The name you provideor the default name will bethe name of the newworksheet with the dataanalysis output.Still on the “Select Variables for Data Analysis” dialog click the Run Analysis button toadd a new worksheet in your Excel workbook that displays Descriptive Statistics andCorrelation Data. The new worksheet uses the “Analysis Name” from the “SelectVariables for Data Analysis” dialog. Here, the default worksheet name is “DataAnalysis 1”.8
Notice that this worksheet displays in a report-type format. Excel worksheet rownumbers and column letters are hidden and the default worksheet gridline is turned off.Scroll down the worksheet (or use the “Zoom” option) to see that the worksheet alsodisplays a series of XY charts that give you a quick visual overview of your results.Turn On/Off Worksheet HeadersYou may find that you need to turn on worksheet headers for an analysis. For example,if a number in the descriptive statistics report is too wide for the default column width,the number displays as pound signs (######). You may want to widen that value’scolumn so the actual number displays. Alternatively, clicking on the cell showing #####will display its numerical value in the formula bar.9
To widen the column, you need to see Excel’s display of Column letters. A quick way tocontrol the display of headers (row numbers and column letters) is to:1) Choose the “Page Layout” tab on the Excel ribbon.2) Find the “Sheet Options” group on that tab.3) Check the “Headings View” box to display Column letters.4) Widen any report columns that require it (double-click the dividing line between theproblematic column header and the header to its right to automatically widen thecolumn so it displays the widest entry in that column).5) Turn back off column headers.The “Variance” column widened to display all values.The Regression and Forecasting Command Group on the RibbonThis command group on the FSBstats tab contains two buttons: “Regression” and“Forecasting”. Before you use either option, be sure to name the data ranges you’ll beusing in your analysis (use the “Name Your Data” group and its “Create from Selection”button described above or any other Excel range naming technique). Both the“Regression” and the “Forecasting” option indicate data by means of range names.The “Regression” ButtonClick the “Regression” button to open the “Please Choose the Dependent andIndependent Variables” dialog.Choose Regression VariablesIn this dialog a model name and the Confidence Level are preset for you. To changeeither one, click in its text box and replace the default with your own choice. Model10
Name, set at default as Model 1, will be the name of the worksheet with the RegressionAnalysis output. Note that the Confidence Level has to be a number between 0 and 1.(Removing a value from the Confidence Level textbox will create the regression analysisoutput without confidence interval information.)All the variable names (from the range names you’ve assigned) appear in the large list atin the lower half of the dialog. One of those variable names also appears in the“Dependent Variable” text box.DefaultTo run a (multiple) regression analysis of your data you first must identify oneDependent Variable from the drop-down menu and then (multiple) IndependentVariable(s) by clicking boxes next to the variable(s) you want to select.If, for example, you want to run a regression analysis with “Ads” as the dependentvariable and “Comp Price”, “Income”, “Population”, “Time”, “Time Var”, and“Unit Sales” as the dependent variables, you’d make the choices you see in theillustration shown below. A variable can not be both a dependent and an independentvariable. Since “Ads” is selected as the dependent variable in this example, the “Ads”choice in the list of independent variables is not selected.11
You might choose anothercombination. For example, in theillustration at left, “Income” isidentified as the DependentVariable with all the rest of thevariables identified as IndependentVariables.Again, for the regression analysis, ifa variable is identified asdependent it can not also beidentified as independent.Run a Regression AnalysisOnce you’ve made choices for Model Name, Confidence Level, and Dependent andIndependent Variables, click the Run Specified Regression button. The FSBstats softwaregenerates regression output on a new worksheet it inserts in your workbook. The newworksheet tab is named with the “Model Name” from the dialog. If you leave thedefault name, the worksheet name is “Model 1”.12
View the Regression ResultsAs was true for the descriptive statistics report, the report of regression results displayswith worksheet row numbers and column letters hidden and no gridlines. Notice in thisoutput, however, that Excel displays the results in an outline form. A new, narrow panedisplays on the left side of the work area. This blue-shaded outline pane containsexpansion and contraction buttons that allow you to expand or contract sections of thereport.A sample regression results report.Outline mode pane.With all the report sections contracted,the regression results look like theillustration at right.13
With all the reports sections expanded, the regression results look like the illustrationbelow (partially shown).Along with text results, a number ofcharts are available.The “Histogram of Residuals” is theonly chart that displays when its reportsection is expanded.Two report sections — The “ScatterPlots” and the “Residual Plots” reports— contain sub-reports, each of which isa chart.For example, the “Scatter Plots” reportsection contains six plots any one ofwhich can be displayed by clicking thecorresponding expansion icon in theoutline pane at left.In the illustration below the “Ads –vs- Comp Price scatter plot is expanded.14
The “Model Summaries” WorksheetWhen you run your initial regression analysis FSBstats locates the regression results onthe “Model 1”worksheet (or a worksheet with whatever name you’ve specified). It alsoautomatically creates a new worksheet in your workbook named “Model Summaries”.The “Model Summaries” worksheet contains a summary of your regression results.Notice in the illustration below that the right-most column has the label “Model 1”. Thisis a summary of the results for the initial regression. If you gave your analysis anothername, that name would appear in place of the name “Model 1”.If you go back to your data and use it to run a different regression analysis (perhapschanging the dependent variable and the selection of independent variables), FSBstatsgenerates results on a new worksheet it names “Model 2”. The Model 2 results areautomatically added to the “Model Summaries” worksheet. FSBstats arranges the Model2 results to the right of the Model 1 results as long as they have the same dependentvariable, as shown in the illustration below.15
If you continue to run regression analyses, FSBstats continues to add additionalsummary information to the “Model Summaries” worksheet.Run another Regression AnalysisPerhaps you study the results of your first analysis (Model 1) and decide you’d like tochange some of the inputs to the regression. At any time, click the “Regression” buttonin the “Regression and Forecasting” group to open a new setup dialog (the “PleaseChoose the Dependent and Independent Variables” dialog).Choose a different Dependent Variableand a different set of IndependentVariables.Notice that the FSBstats software hasautomatically given this new model itsown name: “Model 2”.Click the Run Specified Regression togenerate a new worksheet in theworkbook holding the regressionreport results. This worksheet’s tabname is “Model 2”.The earlier “Model 1” regression report remains in your worksheet. Generate as manyvariations of the regression analysis as you like. Each occupies its own new worksheet inyour workbook.The Forecasting ButtonThe “Forecasting” button in the “Regression and Forecasting” group is another featureof the FSBstats software. Notice at the very bottom of the regression results report asection with the label “Forecasted” and then the name of the dependent variable in theanalysis.To use the forecasting features of FSBstats, input suitable values in the columns in thislast regression results section and then click the “Forecasting” button in FSBstat’s“Regression and Forecasting” group.16
For example, in the illustration below data has been entered for three different forecasts.The data for each forecast occupies one row. Values must be entered for all independentvariables (here, Comp Price, Income, Population, Price, Time Var, and Unit Sales).With values entered for the independent variables, click FSBstat’s “Forecasting” button.FSBstats calculates the forecast and forecast interval range for each row of valuesentered and adds these to the output.Notice that each row now has a label: “Fcst# 1”, “Fcst# 2”, “Fcst# 3”.Forecasting Troubleshooting NotesNeglect to Enter All ValuesIf you neglect to enter values for all the independent variables before hitting the“Forecasting” button FSBstats prompts you with the dialog below.Attempt to Forecast from a Non-Active SheetIf you return to a model that FSBstats considers non-current and attempt to forecastfrom it, a pop-up box displays to let you know that the Model you want to work withisn’t currently active.17
Answer “Yes” to the pop-up question asking if you want to activate your chosen model.FSBstats activates the model you want to use and you can proceed with the forecastingprocess as described above.Adding New ForecastsYou can always add new forecasts by adding new forecast input values on a worksheetand rerunning the forecast operation. All previous forecast values are overwritten withnew values, so changing any of the old input values will also change the forecasts. (Ofcourse if no changes were made to the previous input information, there will be nochange in the recalculated forecast values.)End of A First Look at FSBstats18
Appendix 1: Turn On/Off Headers & Gridlines - Another MethodFSBstats reports display with headers (row numbers and column letters) and gridlinesturned off. Along with the “Page Layout” tab “Sheet Options” group of commands, youcan turn back on the display defaults in this way:1) Click the Office button at the upper left-hand corner of your Excelworkspace.2) Choose the Excel Options button at the bottom of the display. The“Excel Options” dialog displays.3) At the left of the “Excel Options” dialog choose the “Advanced” option.4) Scroll down to the “Display options for this worksheet” section.5) Turn back on row and column headers and/or gridlines.Your report now displays with row numbers, column letters, and gridlines.Reverse the process to return to the FSBstats report defaults.19
Appendix 2: Install and Un-install FSBstatsRecall that when you open the FSBstats.xlsm file in Excel you see a dialog with threeoptions: Yes – Install, No – Open but don’t install, and Cancel – Close.The document above recommends and describes the first option: Yes.The “No – Open it so I can use it now, but don’t install it” option works like this:Click the “No” button. A new “FSBstats” tab appears on the Excel ribbon but there’s noentry for the software in your Excel Add-Ins dialog. When you close Excel, the“FSBstats” tab goes away; it doesn’t reappear the next time you open Excel.The “Cancel – Close the add-in” option does not open or install FSBstats.20
Delete FSBstats from Your ComputerIf at some point in the future you want to delete the add-in, use Windows Explorer tobrowse to the folder where you have the FSBstats.xlsm file stored. Delete that file.Then, open Excel’s Add-Ins dialog and double-click the name of the add-in you justdeleted. Excel won’t be able to find the file and will display a dialog like the one shownbelow that asks if you want to delete the add-in name from your list of Add-Ins. ClickYes.The software is now un-installed.If you open the “Excel Options” dialog and examine your Excel add-ins, FSBstats shouldno longer appear.21
Appendix 3: Troubleshooting FSBstatsRunning the SoftwareIf you receive a copy of FSBstats on a CD be aware that you must install the software onyour own computer’s hard drive in order to run it. You can not run the software directlyfrom the CD.Printer Definition RequiredIf you do not have a printer defined for your copy of Excel, FSBstats will stop operatingas it attempts to provide regression solutions. This will likely require you to reboot yourcomputer and start your session over. To avoid this problem, configure some kind ofprinter for your copy of Excel. It doesn’t matter what printer you select; FSBstats justwants a printer to be defined.End of Appendices22
Oct 13, 2011 · Notice that this worksheet displays in a report-type format. Excel worksheet row numbers and column letters are hidden and the default worksheet gridline is turned off. Scroll down the worksheet (or use the “Zoom” option) to see that the worksheet also displays a series of XY charts that give you a quick visual overview of your results.
akuntansi musyarakah (sak no 106) Ayat tentang Musyarakah (Q.S. 39; 29) لًََّز ãَ åِاَ óِ îَخظَْ ó Þَْ ë Þٍجُزَِ ß ا äًَّ àَط لًَّجُرَ íَ åَ îظُِ Ûاَش
Collectively make tawbah to Allāh S so that you may acquire falāḥ [of this world and the Hereafter]. (24:31) The one who repents also becomes the beloved of Allāh S, Âَْ Èِﺑاﻮَّﺘﻟاَّﺐُّ ßُِ çﻪَّٰﻠﻟانَّاِ Verily, Allāh S loves those who are most repenting. (2:22
tentive and wary. The same animal may well look at other . 5 . WHY LOOk AT ANIMALS? species in the same way. He does not reserve a special look for man. But by no other species except man will the animal's look . be . recognised as familiar. Other animals are held by the look. Man becomes aware of himself returning the look.
The Offertory Look at the World John Rutter Look at the world, everything all around us: look at the world, and marvel every day. Look at the world: so many joys and wonders, so many miracles along our way. Praise to thee, O Lord, for all creation, give us thankful hearts, that we may see: all the gifts we share, and every blessing, .
Your own provincial exam and unit test will include questions similar to the ones in this booklet! 2. RESIST THE. URGE. TO LOOK AT THE ANSWER KEY until you have given all the questions in the section your best effort. Don’t do one question, then look at the key, then do another and look at the key, and so on. Each time you look at one answer .
Microsoft has introduced look book templates and pre-built web parts to simplify and accelerate the build of an organization’s intranet. The Look Book Templates Microsoft has released 18 look book site templates that can be used to create a SharePoint Online intranet. Look book templates come with pre-configured pages loaded with webparts,
want to know what the future of the United States will look like, look to Florida today. We would add: If you want to know what the future of higher education should look like, look to Florida State University today. We are an institution that delivers every day—in measura
academic writing setting and culture in their respective learning establishments do not prepare them for the conventions of English writing. Abbas (2011) investigated metadiscourse terms and phrases to understand the socio-cultural variances of Arabic and English-speaking researchers. Abbas analysed seventy discussions of linguistic academic journals composed by native speakers of Arabic as .
