P5_3_correlation_test.yxmd

<?xml version="1.0"?>
<AlteryxDocument yxmdVer="2018.2">
  <Nodes>
    <Node ToolID="1">
      <GuiSettings Plugin="AlteryxBasePluginsGui.DbFileInput.DbFileInput">
        <Position x="42" y="54" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <Passwords />
          <File OutputFileName="" RecordLimit="" SearchSubDirs="False" FileFormat="0">C:\chao\business data analysis\project 5 ab testing\round-roaster-stores (1).csv</File>
          <FormatSpecificOptions>
            <CodePage>28591</CodePage>
            <Delimeter>,</Delimeter>
            <IgnoreErrors>False</IgnoreErrors>
            <FieldLen>254</FieldLen>
            <AllowShareWrite>False</AllowShareWrite>
            <HeaderRow>True</HeaderRow>
            <IgnoreQuotes>DoubleQuotes</IgnoreQuotes>
            <ImportLine>1</ImportLine>
          </FormatSpecificOptions>
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText>round-roaster-stores (1).csv</DefaultAnnotationText>
          <Left value="False" />
        </Annotation>
        <Dependencies>
          <Implicit />
        </Dependencies>
        <MetaInfo connection="Output">
          <RecordInfo>
            <Field name="StoreID" size="254" source="File: C:\chao\business data analysis\project 5 ab testing\round-roaster-stores (1).csv" type="V_String" />
            <Field name="Sq_Ft" size="254" source="File: C:\chao\business data analysis\project 5 ab testing\round-roaster-stores (1).csv" type="V_String" />
            <Field name="AvgMonthSales" size="254" source="File: C:\chao\business data analysis\project 5 ab testing\round-roaster-stores (1).csv" type="V_String" />
            <Field name="Right_Name" size="254" source="File: C:\chao\business data analysis\project 5 ab testing\round-roaster-stores (1).csv" type="V_String" />
            <Field name="Phone Number" size="254" source="File: C:\chao\business data analysis\project 5 ab testing\round-roaster-stores (1).csv" type="V_String" />
            <Field name="Street Combined" size="254" source="File: C:\chao\business data analysis\project 5 ab testing\round-roaster-stores (1).csv" type="V_String" />
            <Field name="Street 1" size="254" source="File: C:\chao\business data analysis\project 5 ab testing\round-roaster-stores (1).csv" type="V_String" />
            <Field name="Street 2" size="254" source="File: C:\chao\business data analysis\project 5 ab testing\round-roaster-stores (1).csv" type="V_String" />
            <Field name="Street 3" size="254" source="File: C:\chao\business data analysis\project 5 ab testing\round-roaster-stores (1).csv" type="V_String" />
            <Field name="City" size="254" source="File: C:\chao\business data analysis\project 5 ab testing\round-roaster-stores (1).csv" type="V_String" />
            <Field name="State" size="254" source="File: C:\chao\business data analysis\project 5 ab testing\round-roaster-stores (1).csv" type="V_String" />
            <Field name="Postal Code" size="254" source="File: C:\chao\business data analysis\project 5 ab testing\round-roaster-stores (1).csv" type="V_String" />
            <Field name="Region" size="254" source="File: C:\chao\business data analysis\project 5 ab testing\round-roaster-stores (1).csv" type="V_String" />
            <Field name="Country" size="254" source="File: C:\chao\business data analysis\project 5 ab testing\round-roaster-stores (1).csv" type="V_String" />
            <Field name="Coordinates" size="254" source="File: C:\chao\business data analysis\project 5 ab testing\round-roaster-stores (1).csv" type="V_String" />
            <Field name="Latitude" size="254" source="File: C:\chao\business data analysis\project 5 ab testing\round-roaster-stores (1).csv" type="V_String" />
            <Field name="Longitude" size="254" source="File: C:\chao\business data analysis\project 5 ab testing\round-roaster-stores (1).csv" type="V_String" />
            <Field name="Timezone" size="254" source="File: C:\chao\business data analysis\project 5 ab testing\round-roaster-stores (1).csv" type="V_String" />
            <Field name="Current Timezone Offset" size="254" source="File: C:\chao\business data analysis\project 5 ab testing\round-roaster-stores (1).csv" type="V_String" />
            <Field name="Olson Timezone" size="254" source="File: C:\chao\business data analysis\project 5 ab testing\round-roaster-stores (1).csv" type="V_String" />
          </RecordInfo>
        </MetaInfo>
      </Properties>
      <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxDbFileInput" />
    </Node>
    <Node ToolID="2">
      <GuiSettings Plugin="AlteryxBasePluginsGui.AlteryxSelect.AlteryxSelect">
        <Position x="162" y="54" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <OrderChanged value="False" />
          <CommaDecimal value="False" />
          <SelectFields>
            <SelectField field="StoreID" selected="True" />
            <SelectField field="Sq_Ft" selected="True" type="Int32" size="4" />
            <SelectField field="AvgMonthSales" selected="True" type="Int32" size="4" />
            <SelectField field="*Unknown" selected="False" />
          </SelectFields>
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText />
          <Left value="False" />
        </Annotation>
      </Properties>
      <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxSelect" />
    </Node>
    <Node ToolID="3">
      <GuiSettings Plugin="AlteryxBasePluginsGui.DbFileInput.DbFileInput">
        <Position x="42" y="126" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <Passwords />
          <File OutputFileName="" FileFormat="19" SearchSubDirs="False" RecordLimit="">C:\chao\business data analysis\project 5 ab testing\1 weekly margin.yxdb</File>
          <FormatSpecificOptions />
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText>1 weekly margin.yxdb</DefaultAnnotationText>
          <Left value="False" />
        </Annotation>
        <Dependencies>
          <Implicit />
        </Dependencies>
        <MetaInfo connection="Output">
          <RecordInfo>
            <Field name="StoreID" size="254" source="Summarize: GroupBy - StoreID" type="V_String" />
            <Field name="Week" source="Summarize: GroupBy - Week" type="Int16" />
            <Field name="Week_end" source="Summarize: GroupBy - Week_end" type="Date" />
            <Field name="Sum_Gross Margin" scale="2" size="26" source="Summarize: Sum - Gross Margin" type="FixedDecimal" />
          </RecordInfo>
        </MetaInfo>
      </Properties>
      <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxDbFileInput" />
    </Node>
    <Node ToolID="4">
      <GuiSettings>
        <Position x="366" y="66" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <Value name="do target">False</Value>
          <Value name="target">StoreID</Value>
          <Value name="target level" />
          <Value name="use fields">"Sq_Ft","AvgMonthSales","Sum_Sum_Gross Margin"</Value>
          <Value name="Pearson">True</Value>
          <Value name="Spearman">False</Value>
          <Value name="Hoeffding">False</Value>
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText />
          <Left value="False" />
        </Annotation>
        <Dependencies>
          <Implicit />
        </Dependencies>
      </Properties>
      <EngineSettings Macro="Predictive Tools\Association_Analysis.yxmc" />
    </Node>
    <Node ToolID="5">
      <GuiSettings Plugin="AlteryxSpatialPluginsGui.Summarize.Summarize">
        <Position x="162" y="126" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <SummarizeFields>
            <SummarizeField field="StoreID" action="GroupBy" rename="StoreID" />
            <SummarizeField field="Sum_Gross Margin" action="Sum" rename="Sum_Sum_Gross Margin" />
          </SummarizeFields>
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText />
          <Left value="False" />
        </Annotation>
      </Properties>
      <EngineSettings EngineDll="AlteryxSpatialPluginsEngine.dll" EngineDllEntryPoint="AlteryxSummarize" />
    </Node>
    <Node ToolID="6">
      <GuiSettings Plugin="AlteryxBasePluginsGui.Join.Join">
        <Position x="258" y="66" />
      </GuiSettings>
      <Properties>
        <Configuration joinByRecordPos="False">
          <JoinInfo connection="Left">
            <Field field="StoreID" />
          </JoinInfo>
          <JoinInfo connection="Right">
            <Field field="StoreID" />
          </JoinInfo>
          <SelectConfiguration>
            <Configuration outputConnection="Join">
              <OrderChanged value="False" />
              <CommaDecimal value="False" />
              <SelectFields>
                <SelectField field="Left_StoreID" selected="True" />
                <SelectField field="Left_Sq_Ft" selected="True" />
                <SelectField field="Left_AvgMonthSales" selected="True" />
                <SelectField field="Right_StoreID" selected="False" rename="Right_StoreID" />
                <SelectField field="Right_Sum_Sum_Gross Margin" selected="True" />
                <SelectField field="*Unknown" selected="False" />
              </SelectFields>
            </Configuration>
          </SelectConfiguration>
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText />
          <Left value="False" />
        </Annotation>
      </Properties>
      <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxJoin" />
    </Node>
    <Node ToolID="8">
      <GuiSettings Plugin="AlteryxBasePluginsGui.BrowseV2.BrowseV2">
        <Position x="462" y="30" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <TempFile>C:\Users\SL\AppData\Local\Temp\Engine_35540_52378983846943ce8ef9e332a0180335_\Engine_1884_0bb86099842b4bbfa026f43ff14f711d_.yxdb</TempFile>
          <TempFileDataProfiling />
          <Layout>
            <ViewMode>Single</ViewMode>
            <ViewSize value="100" />
            <View1>
              <DefaultTab>Report</DefaultTab>
              <Hints>
                <Table />
              </Hints>
            </View1>
            <View2 />
          </Layout>
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText />
          <Left value="False" />
        </Annotation>
      </Properties>
      <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxBrowseV2" />
    </Node>
    <Node ToolID="7">
      <GuiSettings Plugin="AlteryxBasePluginsGui.BrowseV2.BrowseV2">
        <Position x="462" y="78" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <TempFile>C:\Users\SL\AppData\Local\Temp\Engine_35540_52378983846943ce8ef9e332a0180335_\Engine_1884_de7c3db913b044afad99abe983440246_.yxdb</TempFile>
          <TempFileDataProfiling />
          <Layout>
            <ViewMode>Single</ViewMode>
            <ViewSize value="100" />
            <View1>
              <DefaultTab>Report</DefaultTab>
              <Hints>
                <Table />
              </Hints>
            </View1>
            <View2 />
          </Layout>
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText />
          <Left value="False" />
        </Annotation>
      </Properties>
      <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxBrowseV2" />
    </Node>
  </Nodes>
  <Connections>
    <Connection>
      <Origin ToolID="1" Connection="Output" />
      <Destination ToolID="2" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="2" Connection="Output" />
      <Destination ToolID="6" Connection="Left" />
    </Connection>
    <Connection>
      <Origin ToolID="5" Connection="Output" />
      <Destination ToolID="6" Connection="Right" />
    </Connection>
    <Connection>
      <Origin ToolID="3" Connection="Output" />
      <Destination ToolID="5" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="4" Connection="Output" />
      <Destination ToolID="8" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="4" Connection="Correlation Matrix" />
      <Destination ToolID="7" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="6" Connection="Join" />
      <Destination ToolID="4" Connection="Data Input" />
    </Connection>
  </Connections>
  <Properties>
    <Memory default="True" />
    <GlobalRecordLimit value="0" />
    <TempFiles default="True" />
    <Annotation on="True" includeToolName="False" />
    <ConvErrorLimit value="10" />
    <ConvErrorLimit_Stop value="False" />
    <CancelOnError value="False" />
    <DisableBrowse value="False" />
    <EnablePerformanceProfiling value="False" />
    <DisableAllOutput value="False" />
    <ShowAllMacroMessages value="False" />
    <ShowConnectionStatusIsOn value="True" />
    <ShowConnectionStatusOnlyWhenRunning value="True" />
    <ZoomLevel value="0" />
    <LayoutType>Horizontal</LayoutType>
    <MetaInfo>
      <NameIsFileName value="True" />
      <Name>3 correlation test</Name>
      <Description />
      <RootToolName />
      <ToolVersion />
      <ToolInDb value="False" />
      <CategoryName />
      <SearchTags />
      <Author />
      <Company />
      <Copyright />
      <DescriptionLink actual="" displayed="" />
      <Example>
        <Description />
        <File />
      </Example>
    </MetaInfo>
    <Events>
      <Enabled value="True" />
    </Events>
  </Properties>
</AlteryxDocument>